Not exectly sure what the heck the parameterized query really means. Does it always use sp_executesql? like: DECLARE @UserName NVARCHAR(255) SET...
It seems like this is the only exam needed for the new MCDBA: Exam 70-431 http://www.microsoft.com/learning/mcp/mcts/sql/default.mspx Is this true?
Hello all,<br /><br />Curious thing, when I log onto the remote server through Remote Desktop(windows 2003) and set up the trace. Then when I...
Hi all, I am wondering if the new tuning tool Database Tuning Advisor really apply the statements to the production database? I know the replay...
Hi, I am looking at the MSDB tables such as restorehistory and restorefile, but they are empty... I know I just restored the master database, and...
Hi, How can I list permissions of specific sql account in sql 2000. EnumServerPermissions method only works with SQL 2005 Thanks
Hello,<br /><br />I am having an issue in that I loose counters when I try to open the saved Counter Logs file that collects counters from remote...
Hi all, Is there a way to add a column that does not allow nulls and does not have a default to an existing table: alter TABLE [dbo].[MyTable] add...
Hi,<br /><br />Is there a way to find out who (NT username) installed sql server?<br /><br />Tnx[<img src='/community/emoticons/emotion-5.gif'...
Hi all, I tried to replay the trace I captured from Production database on another server's copy of that database, for obvious reasons. When y0ou...
Hello,<br /><br />Thought I posted that one before, but it didn't show..Anyways, I am not sure what the diffrence is in capturing SQL<img...
Hello all,<br /><br />When running SQL 2005 Profiler, there're 2 choses that Iam looking at:<br />SQL<img src='/community/emoticons/emotion-7.gif'...
Browsing through some web sites, I found this: To repair or modify SQL server components after the service pack is installed Use Add or Remove...
I wonder why even if my NT account is in Local Administrators on the machine, if I remove BIULTINADMINISTRATORS from sql, and add my NT account, I...
I was not able to create assembly when my .NET project was compiled on the remote machine. For instance this failed: CREATE ASSEMBLY StringConcat...
After I drop my assembly I can still execute my UDA, such as: CREATE ASSEMBLY ASSEMBLY_NAME authorization [DBO] from 'c:CLRmyexapmple.dll' WITH...
I notice a lot that at the end of stored procedures some people place error trapping like: SET @ErVar = @@Error RETURN @ErVar Is this the same as:...
Hi, I seem to recall that there was an export/import wizard accessible right from the Management Studio, under tools or something, but now I can get...
Hi all, As much as I resent saying farewell to Taskpad, I can't find alternative tool to quickly see the FREE SPACE left in the database files....
I've actually never had to do this, but just in case I need to restore the secondary, I think to speed up the restore I could just RESTORE LOG...WITH...
Separate names with a comma.
