Hello Team, I am preparing for exam 70-443 and exam 70-444. Please let me know where to start? Normally how much depth of knowledge is needed to...
I want the properties of my database to be unavailable to any user. Could you please tell me how to do this setup?
I find following options when I want to shirk the database files. 1. Compress pages and then truncate free space from the file 2. Truncate free space...
I have found one table in the database when I expanded this in the management studio. The name of the table has '-' in it. For example the name of...
Dear all : I got a problem which state at event log as following during the backup Exec 9.1 with SQL server 2k under SQL aagent 9.1, please...
I have access to application pools and and I can see the web sites as well. How can I find out the name sql server which is backing up these sites?...
Hi Team, Yesterday I got following information in event viewer in one sql server. "This instance of SQL Server has been using a process id of 1512...
Hi, Can I find out the user who has executed the job? The result of query Q1) gives this information in the message column of the output. Q1) select...
Is there any table where we have source connection and destination connection information about the DTS packages? None of these tables in the msdb...
I have two questions for the experts:1. There are 2 steps in one job. Even if one is succeed then EXECUTE @IRetval =...
When I issue the command to create Mirror partner from principal DB in Mirroring step.ALTER DATABASE TestMirrorSET PARTNER =...
I have created one Mirror DB ('QuestMirror') for the principal one. This is in Restoring mode now. Now I want to get snap shot (SnapshotDatabase)...
Hi, I am unsuccessfully trying to load data from xml file to MS SQL Server 2005 with the query as follows:DECLARE @xmlDoc XML SET @xmlDoc = ( SELECT...
I want to find out the tables and respective count of their records. For this I am using the following query. This is not working properly. DECLARE...
Separate names with a comma.
