Viewing 15 posts - 35,656 through 35,670 (of 39,804 total)
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
low and high depend on your system. I've had 11k/sec for some systems that maxed the server and 100/sec for other systems.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 -...
December 10, 2003 at 5:26 pm
Got to some job that is running it. Could be a job running from somenoe's desk as well (scheduled tasks). Run a trace (profile ) for that time and see...
December 10, 2003 at 5:24 pm
you can also use the table datatype to return some data to the calling procedure though the suggestion above is the more straightforward way.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com...
December 10, 2003 at 1:19 pm
done!!!!!
thanks for the note and complement.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 10, 2003 at 12:16 pm
Don't think so. You can probably apply for the Beta,http://www.microsoft.com/sql/evaluation/betanominations.asp
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 9, 2003 at 8:21 am
Boy, I don't have Yukon handy (on the road), but it seems to me that it performs pretty well. If you've used Visual Studio, it performs like that, pretty well....
December 9, 2003 at 8:18 am
Sure can. Set the permissions for each db as though it's the only db. If you need cross db joins, the user must be in both dbs adn you qualify...
December 8, 2003 at 11:38 pm
You should be able to create a role, deny permissions to all tables for the role except the table you want and then do it that way.
Alternatively you could...
December 8, 2003 at 11:37 pm
you could set default values in the definition of the parameters for the proc and then not pass anything in. Or check to see if you want defaults with and...
December 8, 2003 at 5:58 pm
Also any network "drives" you have need to be mapped permanently WHILE YOU ARE LOGGED in as the MSSQLSERVER account. Not using your account.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com...
December 8, 2003 at 4:46 pm
Viewing 15 posts - 35,656 through 35,670 (of 39,804 total)