Viewing 15 posts - 39,226 through 39,240 (of 39,466 total)
I'd agree with Wes. If you can do 0+1, I'd do that, even if I combine tempdb and the data files.
Steve Jones
October 15, 2001 at 2:34 pm
I am with Jon. Can you post some samples so we know what you mean? I am guessing that you will need separate queries of each "round" or set of...
October 15, 2001 at 2:31 pm
I think your parameter is looking for an a: drive. There is probably a dialog asking for you to insert a disk.
Steve Jones
October 15, 2001 at 2:26 pm
You may need to allow updates
sp_configure 'allow updates', 1
reconfigure with override
then recompile the stored procedure.
Steve Jones
October 15, 2001 at 2:20 pm
You might also want to detach your dbs and make a copy of the raw mdf/ldf/ndf files.
Steve Jones
October 15, 2001 at 2:17 pm
Look them up in BOL, but basically you split your table by the PK into 2 parts. If your table is orders using an OrderID (int) as a PK, you...
October 12, 2001 at 3:51 pm
run from command prompt:
osql -Sserver -E -Q"select * from test1" >> file.txt
Or run from DTS package.
Steve Jones
October 12, 2001 at 2:33 pm
or you can use
xp_cmdshell 'osql -Sservername -E "sp_helpdb" > test.txt'
etc.
Steve Jones
October 12, 2001 at 11:32 am
What you need to do is handle this in the ASP.
Use your loop to check for the name and only print it (and a new line) if the name has...
October 12, 2001 at 11:23 am
Also, MCSEs retain their cert. There will not be MCSE 4 and MCSE 2000.
In addition there is a new sys admin cert MCSA.
Steve Jones
October 12, 2001 at 9:47 am
I wouldn't run this from a trigger. If you have problems, then the transaction would fail. I'd use the trigger to insert the record into a staging table with a...
October 11, 2001 at 9:33 am
When you say 3 RAID 5 disks, is this one RAId-5 array with 5 disks of 18GB apeice?
If so, just make a single file/filegroup. I have usually split the system...
October 10, 2001 at 4:06 pm
Can you give us a better idea of what is inside the packages? Is it a single connection/T-SQL task?
Also, what is different about the client machines? Did you check to...
October 10, 2001 at 4:02 pm
In 2000 there are a number of collation type options that can be reset per db. In 7.0, I do not think this is an option. Sorry, I do...
October 10, 2001 at 4:00 pm
October 10, 2001 at 3:54 pm
Viewing 15 posts - 39,226 through 39,240 (of 39,466 total)