Viewing 15 posts - 271 through 285 (of 346 total)
Check this thread - there's several scripts posted: http://www.sqlservercentral.com/Forums/Topic432483-146-1.aspx
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
December 17, 2007 at 3:04 pm
Seems strange. I have a nearly identical setup, but it works for me (using a SQL Server authentication rather than Windows authentication).
The login should not need any...
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
December 16, 2007 at 1:43 pm
Some earlier Gb cards didn't have the option to set Gb speed/duplex directly, you had to set it to auto-neg. Not sure if that can be fixed by an...
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
December 16, 2007 at 1:35 pm
Another alternative is to run this:
exec sp_msforeachdb 'exec sp_helpdb ?'
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
December 16, 2007 at 1:23 pm
You could add some logic utilising IF DATABASEPROPERTYEX([dbname], 'Status') = 'ONLINE'...
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
December 16, 2007 at 1:12 pm
DBF? Sounds like another product's equivalent of an MDF or MDB, which you can't import directly to the best of my knowledge - you need to have that database...
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
December 13, 2007 at 8:12 pm
Are your NICs set to auto-negotiate or set to a fixed speed/duplex? I've had problems with auto-negotiate in the past.
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
December 13, 2007 at 4:15 pm
The target size in DBCC SHRINKFILE is actually in megabytes, so what is given above (5120) will actually give you a 5GB file size.
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
December 13, 2007 at 3:00 pm
What profiles have you configured for Database Mail? What profiles are public? What profile are you specifying in the sp call?
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
December 13, 2007 at 2:56 pm
Sorry, don't have an answer for that one. I'm not sure if SQL Server uses the views that DBCC updates or hits the tables themselves when it comes time...
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
December 12, 2007 at 5:18 pm
If you know the rough per-day growth rate, multiply it by the number of days you expect the database to be around for and set the database size to that...
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
December 12, 2007 at 4:28 pm
What you're missing is that you need to be fiddling with DATABASE roles, not SERVER roles. Access to tables, stored procedures etc is governed by the database roles within...
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
December 12, 2007 at 4:18 pm
I haven't come across any. Last time I had to do that sort of thing I wrote a VBS script to handle it (delete files older than x). ...
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
December 12, 2007 at 4:06 pm
Explain how a differential backup works. I had that one in my last interview.
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
December 12, 2007 at 3:51 pm
What happens if you try running:
master..xp_cmdshell 'D:\JPMorgan_IMPORT\pdfcombine.exe D:\431411406.PDF D:\431411408.PDF D:\COMBINED.PDF'
Are any error messages returned? Or is it just the never helpful 'NULL'
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
December 12, 2007 at 3:23 pm
Viewing 15 posts - 271 through 285 (of 346 total)