That's the approach I have always used. 

I had to do this once a few years back.  Here is a good artical that goes over the creation of a data source to SQL Anywhere.

http://www.aspfree.com/c/a/MS-SQL-Server/Using-DTS-Import-FromExport-To-a-NonMicrosoft-Database/2/

I would suggest storing the GUID in a varibale prior to doing the insert.  Taht way it is pre-stored for use later in the query.  For example:

DECLARE @guid_value VARCHAR(255)

SET @guid_value...

I don't think you can.  Generally you must be the owner of the object (dbo) to run set commands against them.

Generally in this case I would just drop the existing constraint and add the new new one.  If you do this through Enterprise manager while running a server trace you...

I would think you could use a case statement in the SELECT clause. 

SELECT CASE WHEN artist not LIKE '%,%' THEN artist ELSE left(artist, charindex(',', artist)) END

or somthing...

Are you trying to view the actual logs under Management...SQL Server Logs?  If so these files can get very large and thus take a long time to open.  If you...

There are a couple of ways to do this:

1.  Use the detach and attach method.

-  This involves copying the database files from one server to another and then attaching them...

Off the top of my head you could use the sp_droprolemember and sp_addrolemember.  The only problem is that you must be a member of the sysadmin fixed server role, the db_owner or...

I had to do something similar to this before and accomplished it like this:

SELECT SUBSTRING(CONVERT(VARCHAR(25),DAT,121),1,14)+'00' AS DAT,VALUE

INTO ##TEMP

FROM TEST001

SELECT DAT, SUM(VALUE)

FROM ##TEMP

GROUP BY DAT

Not the best method, but it was...

The whole process to restore the master database usually only takes a few minutes.  If this is occuring on the same server that master was backed up from then that's...

Users who need to view agent information like jobs and schedules can be added to a role within the MSDB database called TragetServersRole.  This should allow them to view the...

What this requires is putting the server in single user mode.  This can be done by the following proccess:

1.  From Command Window, run NET STOP MSSQLServer.(

A with Move error usually means that the database restore is trying to put the data and log file in the same location as the server that it was backed...

I am pretty sure you are going to have to switch to use DATETIME instead of SMALLDATETIME.  SMALLDATETIME stores Date and time data from January 1, 1900, through June 6,...