azdeji (3/12/2012)

---

Thanks for getting back to me, the problem I'm having now is that the filename structure below will keep changing through the depending

Projects_Russia_8_01_Country_Prog_V2_0_LFD_Project_Definition_SD

“Country”“Template No. and “LFD_CP_Goals “SD” -These parts...

you can try setting it to single user mode. then after you restore alter the database back to multi-user mode. is should work and will kill any connections...

Sean Lange (3/12/2012)

---

So you do know that the people that help around here are volunteers right? You did not provide anything other than a 300 line proc. There is no...

did you change the password in your configuration you posted to the web?? if not i would go change that now.

Please see this link http://www.sqlservercentral.com/articles/Best+Practices/61537/

as far as the proprietary make up the data, make up the names. we dont need your production data but we do need something like...

ok ill get past the multiple logins which seem to be the same person.

to get the various options you want you just keep adding case statements, so if you wanted...

there are 3 options i see, dynamic SQL based on the file name or 28 stored procedures, one for each file. for the dynamic SQL it may get complicated...

here is a msdn article for the DST to ST switch (fall Back) and from it i think we can safely guess the jobs wont run. since the time...

looks like this post is for this thread. http://www.sqlservercentral.com/Forums/Topic1263956-1292-1.aspx

however that query is hella ugly and really could be rewritten to work much faster as you are only working on...

We can probably help. it will most likely take 2 inserts. other than that not much any one else can do with out sample data and table definitions.

Please...

Along with bulk copy you could also use an SSIS package. might take a little work but you can also do some data transformation with the ssis package as...

you can look at the SQLAgentReaderRole. this might be the solution you are looking for. check out the msdn article at the link

http://msdn.microsoft.com/en-us/library/ms188283.aspx

use msdb

EXECUTE sp_addrolemember 'SQLAgentReaderRole', 'username'

GO

EDITED TO...

if the scripts you are referring to are the T-SQL scripts, you can schedule a one off sql server agent job to run the script. in the scheduling section...

SQL KnowItAll thanks for pointing out the TVF's made this alot more efficient. krhind, Here is the function followed by the query that will produce your requested output. ...

i am not familliar with TVF's off to the all mighty google to eliminate my while loop