Forum Replies Created
Viewing 15 posts - 35,596 through 35,610 (of 39,769 total)
-
RE: Print out forum topic
honestly, never thought about it. We'll add it to our list.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Beyond 8 GB memory
Someone with more experience will need to check, but I thought that above 8GB you turned AWE off and ran with just PAE enabled.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com...
-
RE: Elevate permissions within stored procedure
How time critical are these? One thing you could do is have the proc insert some values into a temp table, including their user name (suser_sname()) and then have a...
-
RE: EM not showing Databases or Management
Hmmm, that's strange. Can you run profiler and see if it's actually sending queries. Have you changed your pwd recently? Can you run queries through QA to this server with...
-
RE: Insert into select from taking hours (URGENT))
Good suggestions above, one other point. If the database grows during the insert, while it grows, ALL activity stops. That could be the issue. Has the extra long time occurred...
-
RE: Yukon DTS packages
Not sure about all the changes, but we have an article coming in the Jan issue of SQL Server Standard (http://www.sqlserverstandard.com/). Not that helps you internationally, but maybe we'll get...
-
RE: Yukon Release Dates
That's about what we got at PASS. Feeling was that late 2004 might be ambitious. Might be early 2005.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: How to schedual DB integrity checking seperately
Is this SQL2000? checkdb runs better with this version, but it still takes some resources. It also runs for the whole db.
you can change some options, see BOL for them.
Steve...
-
RE: EM not showing Databases or Management
Something must be wrong with EM. Have you applied SP3? Might want to reapply to your workstation.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Passing parameters from a Trigger to DTS
how are you running the DTS job? xp_cmdshell/dtsrun or sp_Start_job?
In general I'd say that this is a bad idea.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Using ERWIN data Modeller
I think you need to set a new connection. Then enter the values for server, db, etc.
I had an older version of Erwin and I don't remember this being that...
-
RE: Usage Memory in SQL
SQL will take as much memory as it needs and balance itself with other applications, though this can be slow. The OS should manage this, but it might not work...
-
RE: Moving databases to new development box
sp_attach is one of the two best ways, depending on whether you can tolerate downtime. Backup/restore is the other.
Don't use the wizard, IMHO it doesn't work well.
the other thing you...
-
RE: Very minor web site spelling "mistake"
done. Any more, my valued copy editor?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Duplicate Indexing Woes
Perhaps the best plan is not to use Sysmaint, but it's a quick and easy and relatively foolproof way to ensure a server is setup quickly. Especially when we have...
Viewing 15 posts - 35,596 through 35,610 (of 39,769 total)