SQL 2005

How to move the msdb database to sql 2005

I have a server running sql 7.0 and I need to move the msdb database to another server running sql 2005. When I try to restore the db from a backup I'm getting a compatability error message. Any suggestions greatly appreciated.

Address segregation in SQL 2005

I am working in SQL 2005 and would like to parse an address filed such as "1234 N CLARK ST APT 111 " into seperate fileds like House Number/Street Name/Street Type ie LN ,ST, or Cir/Apartment Number

SSL on SQL 2005 Express

Hi, I am attempting to encrypt the connection string to/from my database server. I cannot seem to find guidance on where [what directory] to place the CA certificate. I am working with a Windows Form application that call to the data store. Any assistance will be appreciated.

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 BCP. Can any one...

SQL SERVEUR 2005 SISS AND WHERE statement

I create a SSIS to transfer the date from AS/400 TO SQL Server 2005, and it's work fine. when I go to modify it and I add a where statement to choose only the year 2008, I received the following error code 0x80131937

Limit admin access to a single database SQL2005

I want to set up an account similar to sa but limit the rights to a particular db.

Migrate FROM SQL2005 Ent. TO SQL2005 Standard

We recently installed and have been running SQL 2005 Ent. because that is what we planned to use. During the 180 day window our needs have changed and we purchased Standard edition rather than Enterprise. Now we need to migrate from Enterprise to Standard. My question is what is the best way to...

indexes on a large table

hello, i got a 5milion rows on a single table, my database is sql2005 and my select is : SELECT top * FROM tbl1 WHERE ip_from <= 3515134258 and ip_to >= 3515134258 the 3515134258 is on a sample but the format is similar: SELECT top 1 * FROM tbl1 WHERE ip_from <= [value] and ip_to...

SQL 2005 trial version update

I installed SQL 2005 trial version on a production server and the 6 months are almost up. I would like to go to SQL 2008 since I can get a very good deal for it. What options do I have? Can I just upgrade over the trial version or I need to uninstall 2005 and reinstall 2008. The 2005 is a trial for...

Accessing an SQL 2005 Synonym with ODBC

Is there a way to link to a synonym in SQL 2005 using ODBC and MS Access?

SQL 2005 and Security Account Delegation

I read this feature for SQL2000 SP3 but I wonder if this is still valid for SQL2005 or, if it has changed which is the new feature that enables to retain the authentication credentials of the original client.

How to create a temporary table in sql 2005 via SSIS

I need to load a flat file into a temporary table. So I need to know how to step by step how to in SSIS "Data Flow Task" create a temporary table, load one col from the flat file to the temporary table along with the date it was loaded. I will then use the temporary table to delete from another...

PHP or HTML

I need to create a database that allows a user to query info. on a project,name, proj number, contacts, contact #, etc. We are using SQL 2005. The office manager will enter info. about each project into an access form. Then, from the HTML page a user can f search by project name or number to list...

SQL 2000 and 2005 Offline Table Reindex Determination

Hello, I have prcessed SQL 2000 offline reindexes in the past for specific tables when there was scheduled downtime, but I was wondering if there is a tool or script that I can run for a specifc SQL database to determine which tables in the database would need to be reindexed. I do not want to...

I need to move a sql 7.0 database to a different server running sql 2005.

What would be the best way to do that and will the jobs and DTS jobs come with the database? If not how can I move them also. Thanks for any suggestions.

Move/Copy System DB's to new server in SQL 2005

Trying to move system DB's to brand new server (really virtualized server). Server names are different. Any suggestions would be appreciated.

Problem with SSIS & AS400, Source is AS400, Dest is SQL2005

When I'm trying to retrieve data from AS400, I received the below error: The column status returned was: "Text was truncated or one or more characters had no match in the target code page.". How do I know which code page to use besides the default of 1252?

clustered sql 2000 to sql 2005 upgrade

What can I expect when upgrading a clustered SQL 2000 box to SQL 2005?