Viewing 15 posts - 5,296 through 5,310 (of 6,105 total)
It wasn't what I thought. The article refers to counters not appearing correctly in NT 4 prior to SP 6a. The problem is if the chart file is viewed at...
July 13, 2002 at 8:27 pm
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...
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...
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...
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....
July 13, 2002 at 7:32 am
What SQL Server service pack are you on?
K. Brian Kelley
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...
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...
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...
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
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
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
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
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
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
July 12, 2002 at 8:30 am
Viewing 15 posts - 5,296 through 5,310 (of 6,105 total)