It is not real clear what you are trying to accomplish here. I am going to assume that you are using a linked server from SQL Server to your...

Just my opinion, but things like phone numbers, ssn, zip code, etc... are not numbers (although they contain numerals). Since there would most likely never be any need to...

What version of SQL Server 2005 are you on? There was an issue in an earlier release where the Check Database Integrity Task would not actually run against all...

You can use the properties 'LastBackupDate' (date of last full backup) and 'LastLogBackupDate' (date of last log backup).

I don't see anything available to identify a differential backup though, if you...

Oh - I missed that little detail 🙂

I agree - and that was my recommendation to the OP also. So, basically - we were saying the same thing...:)

Select @@version returns the following:

Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on...

How do you know what value in Row2 to associate with the value in Row1? How do you know that the value 2 belongs to the value 1 in...

I am curious about something. If I followed what you were trying to do, you were trying to move the 'indexes' over to the new filegroup and leave the...

How often do you run log backups?

How often do you rebuild indexes?

Are there any ETL type processes that run on a scheduled basis?

Jeff

Again, yes - that is correct when you setup everything in a SQL Agent Job. Now, try setting that up to run as a maintenance plan and use the...

The .ndf file is a secondary database file - which is defined in SQL Server for that database. I think your only option at this point is to restore...

You don't need to create the database first. You can perform the restore from the .BAK file and the files will be created.

Here is one way (of many):

Declare @len int;

Declare @value varchar(10);

--Set @value = '4567890';

Set @value = '1234567890';

Set @len = len(@value);

Select @value, stuff(stuff(right('000' + @value, 10), 7, 0, '-'), 4, 0, '-');

Jeff

You will need to create a linked server between the two instances and use four-part naming (e.g. server.database.schema.object).

Jeff