Viewing 15 posts - 166 through 180 (of 1,131 total)
xp_logininfo invokes Windows API and does not communicate directly with Active Directory. Message 15404 is a catch all message meaning either permission denied or resource not available. Since...
SQL = Scarcely Qualifies as a Language
June 24, 2009 at 7:49 am
Given foreign key "Table2.Table2Id to Table2.ParentTable2Id" and "Table2.Table2Id to Table2.SourceTable2Id" , then all of the "descendants" within both of these foreign keys must be deleted. The means to determime...
SQL = Scarcely Qualifies as a Language
June 24, 2009 at 7:06 am
Extended stored procedure xp_logininfo can list the Active Directory groups of an account. An example execution is:
exec master.dbo.xp_logininfo 'IBM-5C01DE43A36\cfederl' ,'all'
From Books OnLine:
If account_name and all are specified, all permission paths...
SQL = Scarcely Qualifies as a Language
June 24, 2009 at 5:30 am
When you run in a transaction, could you be getting blocking on the source server?
SQL = Scarcely Qualifies as a Language
June 24, 2009 at 5:18 am
Sorry about the delay,but the NTFS decided to misbehave on my business laptop and spent yesterday getting windows re-installed.
First, the term "Triangle Join" is a wonderfull term that easily conveys...
SQL = Scarcely Qualifies as a Language
June 23, 2009 at 3:18 pm
There is absolutely no need to create a Tally table in Master. If you don't want to have that very useful tool in every database, you should make a Utililty...
SQL = Scarcely Qualifies as a Language
June 22, 2009 at 8:37 am
When you state "restart it", do you mean that you turned off the power ?
Powering off a workstation could have corrupted the file system. To diagnose, go to "run"...
SQL = Scarcely Qualifies as a Language
June 21, 2009 at 10:27 pm
I have some SQL similar to what you are trying to perform for Last In First Out inventory allocation, that may get you started.
The data has four Wharehouse and each...
SQL = Scarcely Qualifies as a Language
June 21, 2009 at 10:21 pm
Joe Celko has written 2 article on implementing FIFO and LIFO with SQL.
http://www.dbazine.com/ofinterest/oi-articles/celko32
http://www.dbazine.com/ofinterest/oi-articles/celko33
SQL = Scarcely Qualifies as a Language
June 21, 2009 at 10:37 am
For clusters, there is an intermentant bug in SP2 where the mail stored procedures are not updated. There are also a few other changes that need to be made...
SQL = Scarcely Qualifies as a Language
June 21, 2009 at 9:30 am
Ran your two SQL statements and there are differences in both the statistics io and query plans. But the two SQL statements are not logical equivalent. The Sub-Query...
SQL = Scarcely Qualifies as a Language
June 19, 2009 at 12:53 pm
I find that the only the checkdb maintenance plan is of any use and the other plans lack the necessary functionality. I use SQL stored procedure in the master...
SQL = Scarcely Qualifies as a Language
June 19, 2009 at 11:07 am
Kimberly Tripp just had a blog post titled "Why aren't those nonclustered indexes being used?" that answers the question "What percentage of data IS selective enough to use a nonclustered...
SQL = Scarcely Qualifies as a Language
June 19, 2009 at 9:03 am
There is a tradition in contract bridge, that if you win the last trick of a hand with the 7 of diamonds, your partner must buy you a beer.
SQL = Scarcely Qualifies as a Language
June 18, 2009 at 11:46 am
This type of requirement is becoming more frequent with virtualization and consolidation and is easy to solve.
Assume you have
1) TestServer at IP 192.168.2.2
2) TestServer hosts SQL Servers TestServer\Test1,...
SQL = Scarcely Qualifies as a Language
June 18, 2009 at 10:34 am
Viewing 15 posts - 166 through 180 (of 1,131 total)