Viewing 15 posts - 5,431 through 5,445 (of 9,722 total)
SkyBox (7/28/2011)
And what do you mean by "The SAN is a bit overloaded?"
The db's and logs reside on a SAN and it is being worked pretty hard (controllers saturated), but...
July 29, 2011 at 5:03 am
Glad I could help.
July 29, 2011 at 5:01 am
Post that question in a new thread. There are a lot of ways of doing that in SSIS, so I'm sure it can be done in SSRS, but off the...
July 28, 2011 at 8:45 am
Is this an .msi install package or a DVD install?
July 28, 2011 at 8:32 am
Daniel Bowlin (7/28/2011)
Same source, different subject:This bird is most definitely dead.
No. No, it's not. It's just sleeping.
July 28, 2011 at 7:53 am
Ninja's_RGR'us (7/28/2011)
Brandie Tarvin (7/28/2011)
Ninja's_RGR'us (7/28/2011)
July 28, 2011 at 7:46 am
I don't know how it works in other RDBMS, but in SQL Server, the identity function prevents you from inserting new numbers unless you specifically tell SQL that you're inserting...
July 28, 2011 at 7:43 am
Did you review the summary log to see what it said? Or the bootstrap log?
July 28, 2011 at 7:39 am
Ninja's_RGR'us (7/28/2011)
Wow that's so nice. I had heard about it but never played with it. It's like the Loch Ness Monster, so glad I finally saw it 😉
It's...
July 28, 2011 at 7:36 am
Kiara (7/28/2011)
Ninja's_RGR'us (7/28/2011)
What's their let's go home time?
Ah! *comprehension dawns* You mean the time where the work location shifts from the desk to the car and then to the sofa!...
July 28, 2011 at 7:30 am
Don't use the registry. The setting is in the SQL Agent Properties.
See this link: http://blogs.msdn.com/b/sqlagent/archive/2010/10/15/turning-on-verbose-logging-in-sql-agent.aspx
July 28, 2011 at 6:24 am
I understand your problem, but your clients really should do the following:
1) Back up SQL Server locally
2) Back up the SQL Backup location to another drive (network drive, tape drive,...
July 28, 2011 at 6:21 am
Just an FYI, trying to concat anything numerical tends to add it, not to concat it. So you will always need to convert numbers to strings before concateonating to make...
July 28, 2011 at 6:15 am
I agree with Sean that you are playing with fire. However....
IF (SELECT data_type FROM Information_Schema.Columns WHERE Table_Name = 'MyTable'
AND Column_Name = 'MyColumn' AND data_type...
July 28, 2011 at 6:13 am
Viewing 15 posts - 5,431 through 5,445 (of 9,722 total)