Viewing 15 posts - 5,296 through 5,310 (of 6,104 total)
Typically there is a primary key on a table which makes rows unique. If the primary key is something like an integer, then it's really easy to return results from...
K. Brian Kelley
@kbriankelley
July 13, 2002 at 7:18 pm
I want to say while searching for something else I saw an article about not running Performance Monitor through Terminal Services. It was either in the Microsoft Knowledge Base or...
K. Brian Kelley
@kbriankelley
July 13, 2002 at 7:49 am
You might profile the server to watch the connections being made. Verify 100% it is TCP/IP and the only reason I say check is because we had a case where...
K. Brian Kelley
@kbriankelley
July 13, 2002 at 7:44 am
The guest account, like dbo, will be in sysusers because it is a special account. However, even though the entry is in sysusers, the guest account doesn't necessarily have access....
K. Brian Kelley
@kbriankelley
July 13, 2002 at 7:32 am
What SQL Server service pack are you on?
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
July 12, 2002 at 5:22 pm
I'm a little confused, but that's nothing unusual after a long work week.
If the web app is already processing the query and you try to kick one off in QA...
K. Brian Kelley
@kbriankelley
July 12, 2002 at 5:16 pm
Under NTLM, double hop is prohibited by design. One of the work arounds is to set up the linked server connection using a SQL Server login. In this case, you...
K. Brian Kelley
@kbriankelley
July 12, 2002 at 5:02 pm
Another option that doesn't rely on system tables is the INFORMATION_SCHEMA.Columns view. It's basically the same as the query you've generated, but Microsoft should keep INFORMATION_SCHEMA.Columns the same in the...
K. Brian Kelley
@kbriankelley
July 12, 2002 at 4:55 pm
When you say small peer-to-peer, I assume no domain? If not, are you using SQL Server logins?
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
July 12, 2002 at 4:49 pm
Didn't we cover this in a thread a few months back... running a select before the delete to be sure only the desired set was affected?
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
July 12, 2002 at 4:45 pm
The real question is, though, if the puzzle is correct as written, why obfuscate the code in such a way?
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
July 12, 2002 at 9:02 am
The system stored procedure sp_spaceused can be used for this purpose. For instance:
USE Northwind
GO
EXEC sp_spaceused 'Orders'
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
July 12, 2002 at 8:33 am
Please don't cross post. I'm locking this thread because it is posted in Administration.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
July 12, 2002 at 8:31 am
Please don't cross post. I'm locking this message thread because I see it posted in several other places.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
July 12, 2002 at 8:30 am
The DELETE works (build the tables). I'm trying to confirm the puzzle is correctly stated in its current form. If it is, he is an evil, evil man (or rather,...
K. Brian Kelley
@kbriankelley
July 12, 2002 at 8:26 am
Viewing 15 posts - 5,296 through 5,310 (of 6,104 total)