If you need to restore your databases to a new server you need to either have backups of the service master key or the DDL to recreate the Database master...

Wow, pretty impressive. I never considered doing something like that in that way. Thanks for the post.

Best way is to make sure only clean data goes in. 😎

I do something similar to this... hit a number of URLs and download various zipped files, move them to other servers and load them into different databases.

I elected to take...

Does the data from this URL have to be pulled on demand by a client doing a SQL query or is it something that occurs on a schedule or in...

your C# code declares the function as static void, yet the function definition TSQL declares it as returning nvarchar(MAX).

Having said that I'm not so sure what you are trying...

I can buy the fact that SQL Server might call each new page allocation a "split" even though it really isn't a page split in the true sense (i.e. an...

you could be seeing a few page splits due to the index maintenance. All indexes can incur splits as they grow.

I suggest that after running this tsql code to load...

Use try - catch

What error code or error message are you getting? I could be failing for a dozen different reasons. Most likely connectivity or login credential issue if nothing else has changed.

I would write a little .NET program to do this... grab the file from the folder, pre-format/filter it as needed then bulk insert it into a database table or tables....

grant them execute on xp_fileexist

execute xp_fileexist @pathToCheck, @status

if @status = 0

print 'Not There'

Sorry for the double post, my keyboard glitches all the time.

grant them execute on xp_fileexist

execute xp_fileexist @pathToCheck, @status

if @status = 0

I find that it is easier to just shoot them when they act...

You will need to back up your databases on the old server and restore them to the new server. There is no other way to migrate them. You should also...