Viewing 15 posts - 37,006 through 37,020 (of 39,903 total)
You can deny access to a table for dbo, which is the user for sa in a database. However, not sure dbo can own the table, so you might need...
November 19, 2002 at 1:27 pm
SQL is more advanced than NT. 64 bit ready (different version), but the support is
there. SQL works with memory and processors, needs OS support.
Steve Jones
November 19, 2002 at 9:48 am
Not sure what you mean? Is one of the SQL Servers under professional? What versions of SQL?
Steve Jones
November 19, 2002 at 9:43 am
What is the source? Possible a network error? Or unable to gain an exclusive lock?
Steve Jones
November 19, 2002 at 9:40 am
no lock shouldn't matter.
I wouldn't do this. Instead, I'd use a process that runs every minute or so and looks for changes and sends mail. Less likely to cause...
November 19, 2002 at 9:35 am
Use multiplication (*1000) and then division to find things = 00.
Alternatively, change the datatype to numeric and limit to 2 decimals.
Or add a trigger to round to 2 decimals.
Steve Jones
November 19, 2002 at 9:29 am
I suspect the db creation is part of a transaction. IS this restoring any database or only a new database?
Steve Jones
November 19, 2002 at 9:27 am
Bad install. I'd reinstall the tools.
Steve Jones
November 19, 2002 at 9:04 am
Could be performance, mostly for tempdb. Personally, it's a standards thing. We move all the data to a drive and logs to another. May further separate out, but we have...
November 19, 2002 at 9:02 am
Profiler is your only shot
Steve Jones
November 15, 2002 at 4:56 pm
My 2 cents. This is pretty good, though be sure you can deliver what you promise. If you don't you sully your reputation rather than enhance it (for that job).
However,...
November 15, 2002 at 2:55 pm
How long are the locks held? I wouldn't expect most of these to run long.
Steve Jones
November 15, 2002 at 2:44 pm
seems pretty easy in SQL Server as well.
Steve Jones
November 15, 2002 at 2:43 pm
Is your local server set for SQL Authentication?
Steve Jones
November 15, 2002 at 2:42 pm
though by ANSI standard, the order of the rows returned is not guarenteed. If you want a particular 1000 rows, include an order by (which might force a table scan.
Steve...
November 15, 2002 at 2:41 pm
Viewing 15 posts - 37,006 through 37,020 (of 39,903 total)