Not exectly sure what the heck the parameterized query really means. Does it always use sp_executesql? like: DECLARE @UserName NVARCHAR(255) SET...
thanks, I'll try that.
Management Studio, Windows Ecplorer, Command Line window...etc. Profiler doesn't persist.
Thanks Brad, I am finding the total of 6 exams: 70-431 Microsoft SQL Server 2005-Implementation and Maintenance 70-441 Designing Database...
Yes, I am. I wonder why other apps stay open while the Profiler closes though.
I don't see anything in the event log. I am simply trying to trace a server A from server B, and the trace on server B disapears when I close the RD...
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
I am able to open the file on any machine, it's just that the values for the counters are empty.
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...
well, just wanted to know which dba installed this particulat sql server is all, thanks for the reply.
that sounds more like it, because NOT NULL is a property,and will not allow me to change the column from NULL to NOT NULL. But I can create a default...
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'...
thanks
I could create an empty one and DTS all the objects into it, but...how do I specify the dbid in the database create statement?
Well, it was just that the trace didn't find the correct database, since the DBID is diffecrent and is impossible to edit:<br /><br />error:<br />No...
Separate names with a comma.
