I am sorry my previous post was rather incomplete. i was wondering if i can get the schema exported to a pdf file after generating the database...
Hi all, I was wondering if there is a way to generate logical database schema [ depicting all the tables in the database and the relations between...
Thanks for all you support !!
The reason behind trying to put the production database in single user mode is to support a migration project, I need to get the count of the rows...
This is the list of queries that i am using to get the list of foreign keys, primay keys, non clustered indexes , list of user tables and list of...
Based on all you replies, what i understand is the if I have my database ( on promary server) in single user mode, I will not be able to acces the...
Hi all, we have log shipping configured from our production server to QA server. to accomplish somep planned production activities in the near...
I have checked in the sysindexes and sysobjects table even before posting my question. But the filters whci show accurate resutls for one database...
Hi , Thanks for you reply. Using your suggestion I tried to run a job on the different server, when i executed this code it shows that the job has...
Hi , Is there a way to find the number of indexes in a given sql database?? Is there a way to find the total number of objects in a given SQL...
Hi. let us say I have a server A and server B. I want to know if i can kickoff a SQL server job on server B from server A. Any help is highly...
Interesting obeservation: the account which issued the kill command ( to kill the process id 74) is the account under which sql server is running.
Thanks for you tip satya, I have checked in the event viewer security log and found out the user who issued this kill command. But i want to be...
Also I overlooked the SQL Error log on the QA server the first time , I found this suspecious message on the log precisely at the time my database...
Thanks satya for you qucik reply. I will re enable the restore log job after the database is completely restored. I have checked in the log...
Hi, My database on QA server ( which is the destination server in lof shipping ) went into suspect mode. To get this database back on, i have taken...
Thanks all for you replies, This error happenes occassionally, so when ever this happenes i am doing a complete backup from promary server and...
Hi, I have refered to these KB articles befre posting my query in this forum but the topic discussed in the KB are not relevent as we have the latest...
Hi, I am implementing log shipping ( generally successfully) but occassionally I get this error: [Microsoft SQL-DMO (ODBC SQLState: HY000)] Error...
Hi I am not using any third party tool to collect the counters. Also I am using QA and not EM to do the restore process. I have issued the...
Separate names with a comma.
