my rule of thumb is for any table over say, 100K rows or so, data transfers like this should be done using the Import/Export Wizard, or via SSIS, so that...

did you resolve this? when i read it, the first thing i though was it might be database context.
if the database context was master, you'd get that exact error,...

thanks Eirikur, I've got several typical styles I've inherited via copy paste over time  that would be improved that way, I know.
I still have things that are selecting rownum from...

things like logins and user permissions i kind of prefer to do via TSQL instead of a black box tool that is scripting via SMO.

I like Perry Whittle's...

i created this simple parsename function that grabs items left to right. 
so if the item you want is always int eh seventh split, this works great:
/*

From the description, I'm thinking the issue is you have a slow report,and if multiple people hit it, it's slow, bogs down the system, etc.

I don't think there...

when you connect via SSMS, it is using the dns and wins services to resolve an name/alias to a specific IP address; therefor since the server already existed, it would...

this is what i use: 
with extremely rare exceptions, I want @@servername to return the name of the machine.
So if I clone VMOriginal as VMNew, when i connect to...

there's an additional table to join to, the msdb.dbo.sysmail_event_log , where the [description] column will tell you exactly what the issue is;
it's typically an error from the mail server, username...

but the Data you provided...

the root of all harddrives are protected. N'D:\MyTrace.log' is invalid due to those protections.
you pretty much HAVE to put files in a subfolder.

I think that's partially incorrect.
what I read is that a linked server featuring the SQLOLEDB  is deprecated, and must be replaced with a server using the SQLNCLI) driver instead.

easy fix, the path for the file is wrong. it has slashes like a UNC path,a s well as a drive letter. it's one or the other. Maybe you mean...

this was kind of interesting, so I imported the file into a varchar max column, and used two CrLf as the delimiter, and the pipe character as the column delimiter(since...