Viewing 15 posts - 39,211 through 39,225 (of 39,466 total)
I avoid putting the actual SQL in the steps because it creates a point of maintenance. I'd rather create a stored proc and change that if needed.
ckempste:
Not sure what you...
October 18, 2001 at 9:27 am
Perhaps it had a security validation issue for a mapped drive? Sometimes MyComputer hangs when searching for a mapped drive before it times out and displays the "x" for not...
October 16, 2001 at 1:07 pm
What I think you will have to do is have separate queries for each round. You would then need to process these to find out which people have not progressed...
October 16, 2001 at 1:00 pm
The total space is the amount used on disk by the mdf/ldf files. The unallocated is the space in the mdf file that is not used.
So, if I create a...
October 16, 2001 at 10:36 am
There is a SQL 2000 version, same limitations. It's a 5 user (roughly) version.
From MSDN:
Microsoft SQL Server Desktop Engine (MSDE)
MSDE is fully compatible with other editions of SQL Server and...
October 16, 2001 at 10:27 am
October 16, 2001 at 10:27 am
I'd say it depends. If you are moving every table and object and it is a true warm standby server, I'd use log shipping.
If it is a cold standby ,...
October 16, 2001 at 10:20 am
October 16, 2001 at 10:08 am
Stored procedures (my favorite) exist for most every job item you need. It would be easy to also build a GUI interface in ASP/VB/.NET that would manage your jobs.
Personally I'd...
October 16, 2001 at 10:06 am
I agree with Andy overall. In ten years of working with SQL Server, ownership chains cause many more problems than they solve.
The only place where I have seen them useful...
October 16, 2001 at 10:04 am
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
Viewing 15 posts - 39,211 through 39,225 (of 39,466 total)