Viewing 15 posts - 35,611 through 35,625 (of 39,769 total)
Add them to the db role "datareader". This can be done with T-SQL
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 11, 2003 at 5:34 pm
I think you can install QA, but your access to the server requires a CAL.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 11, 2003 at 5:34 pm
Use the varbinary data type.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 11, 2003 at 11:05 am
Good luck! I manage 3 SQL DBAs, 4 DB2 DBAs, and 2 Oracle and boy do we get some good debates going! Enjoy.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002...
December 11, 2003 at 10:24 am
New, while we're trying to get search working better, we substituted Google for the time being.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 11, 2003 at 10:23 am
Log shipping is still there, clustering is better and there is also a new "Database mirror" feature. Haven't tested (yet) so I can't really comment on it, but it looks...
December 11, 2003 at 10:21 am
Alamir's advice should work for you.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 11, 2003 at 10:18 am
No real stadnards and MS changes theirs over time as well. I'd pick something (mine or some others) and stick with it.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 -...
December 11, 2003 at 10:17 am
I believe that they are two views into the same setting.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 11, 2003 at 10:15 am
For smaller scale values, I'm not sure it matters which you choose. I use numeric most of the time.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 11, 2003 at 10:13 am
This is an issue with the token and credentials being sent by the client to the server. It appears (from what I've seen and dug into) to be related to...
December 11, 2003 at 10:07 am
I would call PSS if this happens again.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 11, 2003 at 10:02 am
Correct, physical CPUs only for MS. Other vendors license differently.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 11, 2003 at 9:53 am
I'm kind of split. I like the maintenance plans for the integrity and optimization checks. Easy to schedule and setup and document. We go with 2 plans, one for system...
December 11, 2003 at 9:50 am
no easy way in TSQL that I can think of. If you need to do this for a set, it will be cumbersome. Some type of loop or cursor might...
December 11, 2003 at 9:30 am
Viewing 15 posts - 35,611 through 35,625 (of 39,769 total)