MSSQLTips

I wanted to know if we can automate the SQL process at particular time everyday sending an email with Excel Document attachment. I have a SQL Statement which will provide a particular result, which I want to see and would like to email directly to xyz, abc person automated process in excel format. Please...

Hi, I have taken the full backup of ABC database from SQL Server 2005 and I want to restore in SQL Server 2000. But I am not able to restore, it gives me an error 3241: The media famil on device 'D:\...\ABC.bak' is incorrectly formed. SQL Server cannot process this media family. RESTORE FILELIST...

Hi, I have one table and need to move all data to other 3 tables in different database tables. Eg: Database: ABC TableABC 1 - (Last Name, First Name, Address, Phone No.) to Database: XYZ TableXYZ 1 - (Last Name, First Name) TableXYZ 2 - (Address, Phone No). In TableXYZ 1 and TableXYZ 2 there are also...

dguillory, Have you tried the code in this tip - http://www.mssqltips.com/tip.asp?tip=1070 . Thank you, The MSSQLTips Team

Thanks for the reply again!!! Ok Sir let me say in detail what we want. The table is filled by one application and after it fills other application comes and starts accessing the records. In this application we are having multiple threads to make the process fast and it does not matter how the records...

Thanks for the reply. I need the select statement as I need that record in my application so I need the select statement. And sir right now my table doesn't have any primary key nor the clustered index. I need to get the record from the table based on the PersonName and not the primary key. The table...

Thanks sir for your reply. I have used rowcount because i'm having in mytable one lakh record and I want to use just 5 records per thread and for the same I'm going for multi threaded application and hence I'm using rowcount so that it will retriev just five or one records depending onthe...

Hi all, I'm using SQL 2005. I want to establish a lock in the select statement. For the same i've made a procedure as follows: " CREATE procedure [dbo].[Select_SendNo5ByPersonName](@PersonName nvarchar(50)) as begin set rowcount 1 select * from SendNo where PersonName = @PersonName delete...

Question: Hi, I have a database having more than 300 tables.The Structure of all the tables are same. I want to execute a select query which give output of all columns from all the 300 tables. E.g All the tables contain Employee Name, Employee id, Joining Date ,....................... so i want all the...

This gives me what I want - if I want to really work hard at matching them up IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.db_names') AND type in (N'U')) create table dbo.db_names (NAME varchar(50)) go truncate table dbo.db_names go with DBs(NAME) AS ( SELECT...