SQL Server 2005

SQL Server 2005 or SQL Server 2008

I hav been trying to learn sql 2005 from lyk a month or two and i think i have done a good job. Now i was about to try some security stuff in it but i saw that sql 2008 is in market. Can any body suggest me that what is the difference between the two and can I swich to sql 2008? what ever i learned...

Stored procedures to script table data in SQL Server 2005

Are there any stored procedures or command line utilities that I can use to script out the data from a particular table in SQL Server 2005?

MS Project Server errors

I have Ms Project server 2007(S1), project pro(2007), SharePoint Server 2007(language pack [Turkish]installed on Server 2003 with MS SQL server 2005. I have only one farm. I can see when I create a project on server and client side. however whenever I want to see preview of a task, it gives an...

Convert SAS to Stored Procedure

How do I convert a SAS job into a Stored Procedure to run on MS SQL Server 2005?

Restoring a database after migrating from SQL Server 7 to SQL Server 2005

I am trying to migrate from SQL Server 7 to SQL Server 2005, but when I try to restore the database I get this error: "Processed 120424 pages for database 'COAST', file 'Coast_Data' on file 1. Processed 1 pages for database 'COAST', file 'Coast_Log' on file 1. Converting database 'coast' from...

Spoolersp.exe Error occuring frequrently in Windows 2003 environment running a VB application.

We are running a VB Application in Windows 2003 environment. The database Server is SQL 2005. The Application runs in a separate server and the database in another. Remote Users connect to the application through the Remote Desktop facility. Users can go for direct print as well as save to PDF and...

Storing images in SQL Server 2005 and retrieving them from VB.NET

How can I store images in SQL Server 2005 and retrieve them from VB.NET?

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?

Migrating SQL Server 2005 back to SQL Server 2000

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

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...

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...

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...

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 ...

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?

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?

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?

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...

Microsoft Visual Studio 2008 Express edition

Hello everybody, i recently downloaded the Microsoft Visual Studio 2008 Express Edition. It has Visual Basic 2008, Visual C# 2008, Visual C++ 2008 and Visual Web Developer 2008 (all Express editions). The problem is i dont know where to start. I have programming background. i have programmed in...

Multiple instances with SQL Server

Is it adviceable to put SQL 2000 and 2005 in one single CLuster by putting them in different instances?

Inserting rows and multiple rows in SQL Server 2005 Express

Anyone there who can help me solve my problem? I can’t continue my program because of this problem which I know someone can solve or can suggest the best possible solution. I have a project in my study doing simple accounting program. To facilitate the discussion, I will just show you the three...