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...
Just for knowledge....
Thanks for response Satya, That is sql server 2005. Around 30000 users log in at one time.
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...
Thanks sir for your quick response Regards, Ashish
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...
Hello Satya, That is sp3 and windows xp.
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...
Thanks Madhavan
Oh kool. Thanks. Would this not cause any outage if I open it when the application is running? I work in live environment where many ppl are affected...
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?...
Thanks Satya, I have one question: If the sql server is restarted then the transaction which are running would stop in between and will roll back. I...
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...
Sir I am asking the table which has the information of "user context in which the job was ran under"
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...
1. There are 2 steps in one job. Even if one is succeed then I execute the below code to get whether the job is successful or not. Schedule Id for...
I have two questions for the experts:1. There are 2 steps in one job. Even if one is succeed then EXECUTE @IRetval =...
Hi I want to add one thing here that I don't have administrator rights in the mirror server mc. Would this really matter?
Separate names with a comma.
