Viewing 15 posts - 181 through 195 (of 259 total)
Jakub.Janda (8/3/2012)
Backups are managed by our sysadmin and are stored god knows where.
Scary
August 3, 2012 at 8:22 am
Right, your LDAP credentials may be fine. But SQL Server isn't connecting to the OID Linked Server using LDAP. I know the provider you're using should technically be LDAP...
August 3, 2012 at 7:21 am
I tried on one of my test boxes, SQL Server 2008 Standard:
Msg 166, Level 15, State 1, Line 1
'DROP PROCEDURE' does not allow specifying the database name as a prefix...
August 2, 2012 at 10:52 am
Tis (8/2/2012)
I get errors like:The provider indicates that the user did not have the permission to perform the operation.
Access to the remote server is denied because no login-mapping exists.
Tis
Sounds like...
August 2, 2012 at 9:53 am
durai nagarajan (8/2/2012)
August 2, 2012 at 7:07 am
krypto69 (8/1/2012)
It's set to grow by 10 percent.
Set that to a size in MB instead. At almost 50 gigs, the next time your DB needs to grow, it will...
August 2, 2012 at 6:21 am
Wow, where to start. Before getting into the specifics of the table design, lets talk about monitoring in general. I highly recommend you check out some of the webcasts...
August 1, 2012 at 8:59 pm
MarbryHardin (8/1/2012)
Well you pretty much have to the way that works don't you?
Yes, that's normal application development practice. You should learn to separate what is appropriate at the DB...
August 1, 2012 at 8:36 pm
opc.three (8/1/2012)
SQLRNNR (8/1/2012)
L' Eomot Inversé (8/1/2012)
EL Jerry (8/1/2012)
Revenant (8/1/2012)
crookj (8/1/2012)
L' Eomot Inversé (8/1/2012)
Cliff Jones (8/1/2012)
L' Eomot Inversé (8/1/2012)
bcsims 90437 (8/1/2012)
SQLRNNR (8/1/2012)
Cliff Jones (8/1/2012)
JAZZ Master (8/1/2012)
L' Eomot Inversé (8/1/2012)
Daniel Bowlin (8/1/2012)
ChrisM@Work...
August 1, 2012 at 8:23 pm
Please take this as advice rather than criticism.
I'm going to chime in here with something that is, on a technicality, off topic. Understanding Active Directory permissions is an important...
August 1, 2012 at 8:16 pm
MarbryHardin (8/1/2012)
And consider if you want to supply variables instead of literal values...
August 1, 2012 at 2:42 pm
Actually, that's how BOL defines between as well. The behavior is to be expected.
August 1, 2012 at 2:35 pm
I think you mean you want to reclaim the unused? "Reserved" is the data+index.
What are you autogrowth options set to? Is the database set to grow by a percentage or...
August 1, 2012 at 12:55 pm
I second the idea of SSIS for this purpose. TSQL wizards like Jeff Moden can probably do it all in pure TSQL but for the rest of us goons,...
August 1, 2012 at 12:21 pm
Viewing 15 posts - 181 through 195 (of 259 total)