Viewing 15 posts - 7,441 through 7,455 (of 9,720 total)
CirquedeSQLeil (9/21/2010)
d.qureshi (9/21/2010)
Thank you for your kind advice.
So there is no way to move a table and its data from one physical disk location to different physical disk location...
September 21, 2010 at 10:18 am
I've found Excel only causes a few minor issues and as long as you know how to work around them, it's not that big of a deal.
It's figuring out the...
September 21, 2010 at 8:20 am
george sibbald (9/21/2010)
@brandiesorry, was not ignoring you, just taking a different viewpoint.
Different viewpoints are good. Even moreso when the documentation proves wrong. @=)
September 21, 2010 at 8:08 am
I actually have had errors in the past on this. Even posted a request for help on this forum about it at some point, but no one was able to...
September 21, 2010 at 7:44 am
jcrawf02 (9/21/2010)
Finally! The perfect database tool! :w00t:http://spreadsheets.about.com/od/datamanagementinexcel/ss/080608_database.htm
If they find your body stuff into a Microsoft Office box, they'll know I was the guilty party...
@THWACK!
😛
September 21, 2010 at 6:56 am
Okay, how many different backup jobs (and what types) do you have going on with the failing database?
September 21, 2010 at 6:18 am
Jeff Moden (9/20/2010)
September 21, 2010 at 6:14 am
Have you tested the email without the attachment? Used DBMail manually in SSMS?
September 21, 2010 at 6:09 am
Is the Linked Server in the SSMS GUI? Check the security tab on it and let me know what the set up is.
September 21, 2010 at 6:08 am
Please post whether or not Rich's solution helps you out. It looks interesting.
September 21, 2010 at 6:06 am
Cath Trimble (9/21/2010)
SQL Server 32 bit can't use more than 4GB of memory.
Here's someone who's proved SQL Standard 32bit can use more than 4GB on a 32bit OS:...
September 21, 2010 at 6:05 am
jboudinot (9/20/2010)
set the date column to not null, then it will use the default if you don't supply any data for that column
I've never seen that work.
Every time I've set...
September 21, 2010 at 5:54 am
Then keep doing the tests one at a time until you find out which part of your method changed so much that it's taking 4 hours to do.
September 20, 2010 at 12:32 pm
The error message complains about an OLE DB error. I didn't think Excel used OLE DB to connect. But you're getting the queries to run when you're sysadmin?
What's the security...
September 20, 2010 at 12:29 pm
Viewing 15 posts - 7,441 through 7,455 (of 9,720 total)