Viewing 15 posts - 661 through 675 (of 927 total)
Koen Verbeeck (3/26/2014)
tlally (3/26/2014)
No problem on the local disk so it looks definitely like a permissions issue. How to solve it is the issue as the proxy did not work?
It...
March 26, 2014 at 11:33 pm
Koen Verbeeck (3/26/2014)
If it works in BIDS, but doesn't with Agent, it is in 90% of the cases a permission issue.
+1, it just a guess, just for the sake of...
March 26, 2014 at 7:21 am
Jeff Moden (3/24/2014)
If the content of the column is less than 128 characters, the you could also do the following...
SELECT QUOTENAME(Column1,'''') AS quotedColumn1FROM TableA;
if its more...
March 24, 2014 at 11:04 pm
Koen Verbeeck (3/24/2014)
Nice follow-up question, thanks.
+1, Thanks for sharing
March 24, 2014 at 2:05 am
Anoo S Pillai (3/18/2014)
A nice question, somewhat spoiled by a careless explanation.
You are setting a tough target Tom, Copied the explanation from BOL for un-ambiguity. Sad to see that it...
March 18, 2014 at 11:29 pm
Thats are vary open question you have asked. there is no a detail regarding what kind of problem you are facing. Kindly share us what exactly you are looking for.
March 18, 2014 at 11:29 pm
Jampandu (3/17/2014)
free_mascot (3/17/2014)
Update and Delete both required exclusive lock hence it is natural. To avoid you can BCP data to archieve/delete during offpeack hours.HTH
There is no offpeack hours on that...
March 18, 2014 at 12:41 am
Thats a very nice question to kick start your monday 🙂
no lazy starters
March 17, 2014 at 12:24 am
KWymore (3/5/2014)
CGSJohnson (3/5/2014)
They're actually called features! 😀+1
+100 😀
March 14, 2014 at 7:32 am
yes to can change the set a server alias for an sql server instances
check this link http://www.mssqltips.com/sqlservertip/1620/how-to-setup-and-use-a-sql-server-alias/
March 14, 2014 at 7:16 am
when DML operation is just work as an event which needed to be captured. you need to store old new field values somewhere and then select from that table to...
March 14, 2014 at 6:46 am
There are ways to accomplish this task.
1. Enable the auditing feature in SQL SERVER 2008.
http://technet.microsoft.com/en-us/library/dd392015%28v=sql.100%29.aspx
2. Use Output Clause. http://technet.microsoft.com/en-us/library/ms177564%28v=sql.100%29.aspx
3. Classic Trigger way.
you have to review which process you should...
March 14, 2014 at 5:58 am
Viewing 15 posts - 661 through 675 (of 927 total)