RE: Discrepancy on QOD for 7-28-03
quote: cholliet: The answers where just a bunch of numbers And English is Brian's 2nd language? Cheers, - Mark
2003-07-29
SQL Server Agent
RE: Discrepancy on QOD for 7-28-03
Brian, We do use the common slang in our day to day DBA life. I think that there is nothing wrong on your part. Anyway we can leave this issue and don't need to consider further I guess...
2003-07-29
RE: Discrepancy on QOD for 7-28-03
I'm afraid this question was my doing and English is hardly my 2nd language (although my ex-English teacher may say otherwise). I made the assumption that since I was speaking of GB the entire question, that readers would assume GB. It sounds like that was a poor assumption on my account. It has been fixed […]
2003-07-29
RE: database refresh
Obviously, detatch/attach (with file copy) requires less down time than backup/restore. Any pros and cons with either approach?
2003-07-29
1 reads
RE: Discrepancy on QOD for 7-28-03
cholliet, I was just wondering if you have been offered water with "spoon" or "cup", when you request someone that you would like to have some water.... (not glass of water) I would imagine that you would normally be offered water with glass unless you request yourself. Did you get the point? Think about it...
2003-07-29
RE: extended stored procedures
Exec master.dbo.xp_cmdshell 'dir d:\MSSQL7 /b' the '/b' switch should return only the filenames (and subdirectory names) from the directory... To list only the files Exec master.dbo.xp_cmdshell 'dir d:\MSSQL7 /b/a-d' good old DOS commands....
2003-07-28
RE: extended stored procedures
If I do this way I get additional information: date, time, size…. Is there any way to get only file names? I have to load into table just file names. How to process this output information? Will the name always starts from fixed position?
2003-07-28
2003-07-28
RE: extended stored procedures
EXEC master.dbo.xp_cmdshell 'dir c:\MSSQL7' Of course, replace c:\MSSSQL7 with whatever directory on the server you want...
2003-07-28
2003-07-24
1 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers