Accessing the Northwind database in SQL Server 2005
In SQL Server 2005, I am not able to access the Northwind database. Some people have said that it is built into the SQL Server, but I can’t access it. How would I do so?

Answer Question   |  December 30, 2008  7:44 PM
Northwind sample database, SQL Server 2005

Migrating SQL Server 2005 back to SQL Server 2000
How would I go about migrating SQL Server 2005 back to SQL Server 2000?

Answer Question   |  December 31, 2008  7:42 PM
SQL Server 2000, SQL Server 2005, SQL Server migration

eMail SQL Server Logs
I’m new to SQL Server Management Studio…… Is it possible to set it up to eMail Server Logs to myself? Thanks!

Answer Question   |  December 23, 2008  5:41 PM
SQL Server Management Studio, SQL Server Management Studio Logs

How to write Bcp command to insert data in to a table
Hi, I have a file which contains the data 2:23:3#1:2:4#2:3:5 i have to insert the data in to the table in multiple rows from a single file as #–indicates to be inserted in next row : –indicates next column column1 column2 column3 2 23 3 1 2 4 2 3 5 I need to use [...]

Answer Question   |  January 8, 2009  2:34 PM
BCP Utility, SQL, SQL 2005

Changing databases at run time in SQL Server 2005
I am using Crystal Reports 8.5, Visual Basic 6 and SQL Server 2005. In my server, I have two databases named Eng_School_Database and Guj_School_Database with the same structured tables. I want to change the databases at run time so that the report should contain the data of desired medium. I have tried the following code: [...]

Answer Question   |  January 9, 2009  3:23 PM
Crystal Reports 8.5, SQL Server 2005, Visual Basic 6

Deploying SQL Server Express to host databases off a mapped drive
I am trying to deploy SQL Server Express to be able to host a database off a mapped drive. In an open lab environment, I can get it to open and run a database off a mapped shared drive on a Windows 2003 server. However, when I take it to a client and their area [...]

Answer Question   |  December 31, 2008  3:18 PM
Mapped drives, SQL Server databases, SQL Server Express, Windows Server 2003

Script to restore database permissions during a migration to SQL Server 2005
We are in the process of migrating from SQL Server 2000 to SQL Server 2005, and I’m searching for a script that can transfer and restore the database permissions of all accounts from SQL Server 2000 to SQL Server 2005. I used sp_help_revlog to restore the logins, but I still have to restore the database [...]

Answer Question   |  December 24, 2008  3:13 PM
Database permissions, SQL Server 2000 to SQL Server 2005 migration, SQL Server 2005, SQL Server Database Permissions, SQL Server databases

stored procedure in delphi with oracle
how to match the datatype of the field that is in database and the datatype of the variable that holds the value of the returned value from database using stored procedure.

Answer Question   |  December 29, 2008  1:50 PM
Delphi, Delphi 5, Oracle, Oracle stored procedures, Stored Procedure variables

SQL Writer error message – SQLDUMPER library failed
error sql writer – sql dumper liabrary failed initialization install corrupt or tamper with

Answer Question   |  June 22, 2010  6:09 PM
Error SQL4304N, SQL, SQL writer, SQL Writer error messages, SQLDUMPER library failed initialization

Index Strategy for existing SQL Server 2005 project
Hi All I Newly joined with new Project,My Boss told me that Create Index strategy document which in excisting Project. I don’t where to start. I prepared some documents which is basically saying about Index recomandation,When we have to creat Indexes,and so other stuff which is finding most used Indexes and Unused index on so….on. [...]

Answer Question   |  December 22, 2008  2:30 PM
Database index strategy, Index strategy, SQL Server 2005, SQL Server 2005 index strategy, SQL Server index strategy

Moving data from one DB to another DB in SQL Server 2005
Hi all I got formula to calucalate Row_size of a table Row_Size = Fixed_Data_Size + Variable_Data_Size + Null_Bitmap + 4 Fixed_Data_Size = total byte size of all fixed-length columns Variable_Data_Size = 2 + (Num_Variable_Cols x 2) + Max_Var_Size Num_Variable_Cols = number of variable-length columns Max_Var_Size = maximum byte size of all variable-length columns Null_Bitmap = [...]

Answer Question   |  December 22, 2008  2:22 PM
Data migration, Max_Var_Size, SQL Server 2005, SQL Server 2005 migration, SQL Server migration

Joining Tables in SQL Server
What is the difference between Outerjoin and Left outerjoin.

Answer Question   |  December 20, 2008  10:23 AM
JOIN statement, LEFT OUTER JOIN statement, OUTER JOIN statement, SQL Server development, SQL Server Query, SQL statements

Referencing a calculated column in a SQL clause
This is our SQL code:   Select addrid,addrkey,addrline1,addrline2,addrline3,addrcity,addrplace,addrzipcod,addrtype,addrphone,jobsconame,addrmc1, CASE month(getdate()) WHEN 1 THEN addrjan WHEN 2 THEN addrfeb WHEN 3 THEN addrmar WHEN 4 THEN addrapr WHEN 5 THEN addrmay WHEN 6 THEN addrjun WHEN 7 THEN addrjul WHEN 8 THEN addraug WHEN 9 THEN addrsep WHEN 10 THEN addroct WHEN 11 THEN addrnov WHEN [...]

Answer Question   |  April 19, 2013  7:46 PM
SQL Server, T-SQL

Assigning data distributions to SQL Server 2005 databases
In SQL Server 2005, we have two databases. We want the first one to store tables, and the second one to store views of the tables in the first one. We have achieved this if the tables and views are in the same database, but is there a way to do it with two?

Answer Question   |  December 20, 2008  7:44 PM
SQL Server 2005, SQL Server databases

Error when restoring a SQL Server 2005 database
Every time I restore one of my SQL Server 2005 databases to a point in time, my log shipping restore job fails on my secondary server. Any ideas on how to correct this?

Answer Question   |  December 20, 2008  7:41 PM
Log Shipping, SQL Server 2005, SQL Server database

Corrupting database in an VB.NET application in SQL Server 2005
I have a application in VB.NET with SQL Server 2005 Express Edition. In the last few days, the database is continuously corrupting. I repair it, but the problem continues. I revise my code, but I can’t find transactions errors that could produce the problems. Do you have any general ideas?

Answer Question   |  December 23, 2008  7:40 PM
SQL Server 2005, SQL Server database, VB.NET

CPYTOIMPF – SQL ERROR
I am using CPYTOIMPF to copy AS400 database file to another AS400 database to get the receiver file in .csv format to download to a pc folder. I get a SQL error ” Error occured in SQL Call Level Interface. Function sequence error.” Does anyone know what this error means? I know that my receiver [...]

Answer Question   |  December 22, 2008  5:28 PM
CPYTOIMPF, SQL Call Level Interface, SQL error messages

SQL Column Headings
When I run an SQL statement the column headings I see are the field names. When any of the other members of our team run the same statement they get the field descriptions as column headings. I have compared user profiles and there are no differences. Is there some other place that this setting is [...]

Answer Question   |  December 19, 2008  4:44 PM
SQL, SQL Column Headings, SQL statements

SQL Server 2000 Enterprise Edition upgraded to SQL 2005
I am researching different Hosting companies with dedicated servers that we can look at moving to. I need to know some information when I am looking at these different companies about the SQL server. We are currently running SQL Server Enterprise 2000. I have seen that the companies are offering MSSQL 2005 in Express, Workgroup, [...]

Answer Question   |  December 20, 2008  7:21 AM
Dedicated servers, SQL Server, SQL Server 2000 Enterprise Edition, SQL Server 2000 migration, SQL Server 2005, SQL Server migration, Web hosts

merging 2 rows into 1 row
Hi , i have 2 tables table a m_id name 1 abcd 2 bcde table b m_id id org_name ind_name 1 1192 gold coast 1 1193 fred 2 1196 greg 2 1198 TechTronics i am now generating the report through a sql query whose output shud be id Id Org_name Ind_name 1 1192 or 1193 [...]

Answer Question   |  December 17, 2008  5:48 PM
SQL tables