what is the use of this script ...simple run this statement use <database> select count(*) from information_schema.tables where table_type='Base Table' go ...
From the Desk of Vinod Kumar : MS DPE and Evangelist ________________________________ From: Veer Ji Wangoo Sent: Wed 8/1/2007 8:09 PM To: Subject: SQL 2008...
Hi, Is it wise to delete history records from backupfiles and backupset of MSDB database regularly, to avoid delay in restore process. Please advice. Thanks, ...
Hi, Sagar appreciate your help, any how i have done it FYI. Run this script to check permission for your database users to the tables. ... select distinct...
Here is the already discussed link :-) http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1704.aspx BTW, here is another good option. right click on the SQL...
Hi All, while installing the sql server entreprise edition am getting the popup message again and again installation is not going forward. screen shot attached...
Shyam Sunder <shyam_k25@...> wrote: Hi All, while installing the sql server entreprise edition am getting the popup message again and again...
5566
Neeraj
nrajmalik@...
Aug 2, 2007 3:37 am
Hi Shyam, Attachments are not allowed. Please upload file on some location or paste the message in the mail. Regards, Neeraj ... From: Shyam Sunder To:...
Dear all I would like to know that if i update 5 diffrent tables . i want to know in which table data has gone. second thing i donot have the source code. can...
SQL Server 2008 – Beginning of a New Era August 08, 2007 | 2:00 PM - 3:30 PM This webcast introduces you to the new features of Microsoft SQL Server 2008...
Hello Jeelani, I feel this script will be usefull for You , It works for server level by getting the data from all databases.It will not only give the...
can u give me link for the compare database thanx ... 5, 50, 500, 5000. Store N number of mails in your inbox. Click here. [Non-text portions of this message...
Hi..frnds. i have inserted audio/video files in to sqlserver2005 db by converting data to varbinary format. now i want to retrive the data from that perticular...
guys, select * from sysobjects where type='u' select count(*) from sysobjects where type='u' will work. Thanks, Shaik. Inderjeet Chana <i_s_chana@...>...
Hi , I wish to unsubscribe from this group can u guys guide me. Regards, Srinivas Balan arsalan <arsalanayub@...> wrote: Multiple Job openings at DevASP...
Hi , I wish to unsubscribe from this group can u guys guide me. Regards, Srinivas Balan arsalan <arsalanayub@...> wrote: Multiple Job openings at DevASP...
Dear all, We are using SQL 2005 Std edition on windows 2003. We have production server which is running 24/7 and can't afford any downtime. So for our clients...
The best way to achieve your requirement would be to create a small .NET app and use that for import and export of your files from SQL Server 2005 table. You...
Dear All, When i run profiler i could see lots of entry like : EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters which takes lots of CPU and high duration to...
Your statements are little contradicting, from the details provided by you....I guess that you don't have any high availability solution in your production...
MNC HIRING DATABASE ADMINISTRATORS - URGENT One of the largest IT Company of India requires DATABASE ADMINISTRATORS for following locations.. Team Lead –...
MVPs from the UG space might have already noticed the sudden increase in the User Group membership since yesterday. This is a part of renewed focus from DPE...
Open the SQL Server Agent, then Alerts on your sql server. :-) Disable alerts. http://forums.databasejournal.com/archive/index.php/t-13479.html Thanks, Deepak...
HCL hiring SQL DBAs - Chennai/Noida/Gurgaon One of the largest MNC Information Technology Company of India requires MS SQL DATABASE ADMINISTRATORS for...
Dear all, I checked and find all the 9 demo alerts where running on the production db. but why is it talking so much time to run (its a system procedure which...
