Programming SQL

Remote restore
Hello All: Due to insufficient disk space to copy the backup file over, I intend to perform a local backup on server A and then restore it over the network from server B. Both servers are joined to two different domains that are not trusted. Here's what I've done so far: 1. Taken a backup of the DB on serv... 3 Jun 2010 19:03

Database roles execute
If you give a user datareader and datawriter, does that also give the user execute permissions on the stored procedures, views and user functions? Thanks, Tom ... 4 Jun 2010 03:47

ssms 2005 temp table issue
I'm trying to debug a sql 2005 stored procedure with VS2008. I do this often and have no trouble but today I need to see teh contents fo a temp table. I know I can add code to my procedure to dump the temp table's data into a permanent table but it doesn't seem like I shoul dhaev to do that. If I open ssms and ... 5 Jun 2010 06:00

Help finding first payment date and amount
I have a simple table and I need help finding the first payment date and the amount payed. Here is the table CREATE TABLE [dbo].[Payments]( [MemberID] [nchar](10) NOT NULL, [PaymentDate] [datetime] NOT NULL, [Amount] [money] NULL, CONSTRAINT [PK_Payments] PRIMARY KEY CLUSTERED ( [MemberID] ASC, [Payme... 3 Jun 2010 13:26

Deploy script
Hi, How can I customize the the FOR command below to loop through the files inside the Database folder following the order of the number prefixed in the file name? FOR /R ../Database %%f IN (*.sql) DO sqlcmd -S %1 -d %2 -U %4 -P %5 -i "%%~f" >> Logs/%2_DBInstall.log || goto errors Database folder contain... 3 Jun 2010 12:18

Convert string to uniqueidentifier?
I have a View with a varchar(36) which hold string guid's. I am trying to import that data over to another db-table into a uniqueidentifier column. The import wizard errors out : *** the column is called Customer on both sides *** Error 0xc02020c5: Data Flow Task 1: Data conversion failed while converting ... 7 Jun 2010 10:47

MonthName Year to YYYYMM Conversion
Hi All, I have a column with the rows rtl_yearmonth Apr 2006 Mar 2009 Jan 2010 I want to convert this data like this and insert to a int column. 200604 200903 201001 Thanks Balaji -- Message posted via http://www.sqlmonster.com ... 3 Jun 2010 17:55

SQL Command question
Hi Friends, I'm using sql command scripting like this : GO :setvar ClientPortalName "Patrick" :setvar DatabaseName "ces_" :setvar DefaultDataPath "F:\Data\" :setvar DefaultLogPath "G:\DATA\" use master go print N'$(DatabaseName)' RESTORE DATABASE [$(DatabaseName)] FROM DISK = N'H:\Backup\backup.BAK' ... 3 Jun 2010 05:40

How to use GO with a sql string
Hi Friends, The point is that I'm creating a sql string and executing it with sp_executestring command, how can I use GO command in my sql string construction, let's say if I want ot use different databases then I need to have something like USE DB1 GO USE DB2 GO .... Thanks in advance, Pat ... 2 Jun 2010 18:43

Multiple sessions when using ADO
I'm having the same issue. I have a Delphi application that uses an ADO connection and for some reason the ADO layer is creating mutiple SPIDs and I don't know how to fix it? I have one ADO connection object and my app connects once, but multiple SPIDS are used when executing statements through the ADO layer. From... 2 Jun 2010 18:43