Viewing 15 posts - 39,211 through 39,225 (of 39,456 total)
In general, most monitoring software uses Windows APIs, same as Performance monitor and the load is minimal. The main exception is the disk monitors, though in Windows 2000, these are...
October 15, 2001 at 3:02 pm
Personally I hate installing new software on my servers. I built this solution so that I could quickly and easily move this solution to another server without worrying about registering...
October 15, 2001 at 2:51 pm
Nothing should have changed, but it is possible that the query plans were lost or the stats were removed with the service pack.
You might start with the sP. recompile it...
October 15, 2001 at 2:47 pm
Ditto. Unless MS posts the code for an xp somewhere (I haven't seen any), it is unlikely you will get the code.
you can email sqlwish@microsoft.com and ask.
Steve Jones
October 15, 2001 at 2:39 pm
Database design will be independent of the platform. If you have the design, then the GUI for SQL 7 will make it easy to add tables, keys, etc.
for understanding database...
October 15, 2001 at 2:38 pm
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
Viewing 15 posts - 39,211 through 39,225 (of 39,456 total)