hi team,

i tried this powershell script to run in sql agent job but i cannot get it to work. it says " PowerShell is: 'Access to the path 'D:\BackupLogs' is...

thanks much Clare for your reply,

i came across this post http://www.sqlservercentral.com/articles/Security/65169/ and i'm reading it now. will let you know what happens.

again, thanks!!!

i would suggest using Redgate's SQL Compare, its a great tool especially for this scenario where you need to run a batch of alter scripts. If you dont have this...

marlon.seton (8/13/2012)

---

Even though I knew the answer without thinking about it, I made sure I thought about it, if you see what I mean. Sometimes, making you check up...

i would suggest reporting services over https. its the same setup we have in my current organization.

jim.drewe (7/18/2012)

---

There is way too much to cover here in a post. It is something that experienced DBAs can hash over for weeks. But I will share a...

i forgot to paste the link! http://www.mssqltips.com/sqlservertutorial/205/creating-projects-and-solutions-with-ssis/ 🙂 🙂 🙂

are you familiar with BIDS via MS Visual Studio? this comes installed with the SSMS when you select the BI Development studio during your SQL server installation.

heres a link that...

i would suggest an SSIS package then schedule as you need it to run.

yep, this one worked well for me also. i did upgrading projects of our legacy systems from 200 to 2008 and this scripts were a big help. thanks much 🙂

its better if you cite the error message you are getting and a clear description of what your homework is trying to do. i said trying, not what you want...

Trying to do something complex in an "All-in-one" query instead of using "Divide'n'Conquer" methods.

yup always do your stored procedures in chunks..its the best rule to go ..

ok i think i got it now :), it's because the whole thing is executed as a transaction and not as a statement. so the whole transaction was rolled back....

i got this wrong, i read all your post but am not still sure i got it.

am not sure you can upgrade sql 2000 directly to sql 2012. it has no compatibility level 80. but i believe you can upgrade your 2005 database though.