This is the best I can come up with but I am don't want to use sys.sysprocesses as it is only for backwards compatibility. SELECT b.session_idFROM...
I am trying to write a query that will show me all sessions that are connected to a specific database. sys.dm_exec_sessions does not have the...
There are some developers in our organization that like to write the SQL in their stored procedures like this: SELECT ... FROM ... WHERE 1 = 1 AND...
8
I am in the midst of configuring our new database servers and I am curious about how to place tempdb's files. We have seperate arrays for data, logs,...
Koen, did you end up resolving this issue? I pretty much have the exact same issue. Tomorrow I am going to try applying SP1 and CU2 and see if that...
This ended up being a file permissions issue. I knew it was a permissions problem because making the accounts an admin on the server made the problem...
The SQL Agent, SQL Reporting, and SQL Integration, services will no longer start on one of my SQLServer 2005 servers. The SQL Server service is still...
I originally posted the question because of a system we are developing that will be storing images. I don't think the insert/update frequency is...
Would there be any benefit to storing text and image data in a seperate filegroup from the main data if that filegroup is going to be on the same...
Yes I can. It is odd it is only ever that one server.
When you go to register a server in Enterprise Manager or connect to a server in Query Analzyer you can see a list of all SQL Servers. How does this...
I want to take the results of msdb.dbo.sp_help_job on multiple servers and import it into a table my DBA Repository database. When I went to do this...
Yes I do.
I am having an odd problem with a stored procedure. When I execute the procedure from Query Analyzer or our application, I am getting a NULL for a...
I recently used this statement to reindex two non-clustered indexes on a table containing 27 million rows. I fully expected each reindex to take a...
A DTS package has an owner sid on it. I used sp_reassign_dtspackageowner to assign ownership of the package to a login that is a Windows group...
Yeah that is what I did. It is a pain though. Being able to revoke all permissions from a user with a single statement is something I would think you...
I edited this post. After reading through the BOL a little closer I think I would be revoking object permissions and ALL means SELECT, INSERT,...
I have a database role called ur_test and I granted that role execute on some stored procedures and select on a few tables. The following statement...
Separate names with a comma.
