For me unfortunately although I know what I want to do, due to development of an allergy, I cannot, so I'm in the situation where anything that allows me to...

Of course if you want to be really lazy, convince your boss to buy you a copy of redgate, then you only have to press tab after placing the cursor...

Just realised, mine is 2008 which we are moving from a named instance to the default instance on the other machine, and thought we might rename the databases, but here's...

Have just encountered same myself, after searching through the database, the aforementioned trigger is not the only place where the name of the temporary database is hard coded, it is...

Hi,

You could write a program using the filesystemwatcher class and then call the ssis package

see http://msdn2.microsoft.com/en-us/library/ms136090.aspx

Hi Scottye,

Using the not for replication option does not mean that the trigger is not replicated, it means this (from BOL)

NOT FOR REPLICATION

Indicates that the trigger should not...

Have you added the not for replication clause when creating your triggers

Regards

William

Hi Haris,

Why not just use another udf to return the value, this works on the pubs database to return a list of the author id

IF EXISTS (SELECT *

    FROM  ...

Hi Bah,

You need to pass a recordset to the function.

So to do this you need to create an adodb recordset upfront, and pass that through as the second argument.

Hi,

The way that I do it is to write the recordset to a file, and then use the file as the datasource for the mail merge, here's the function, you...

Hi,

Try this

CREATE FUNCTION dbo.ufn_Split

(

 @StringIn nvarchar(2000),

 @Delimiter nvarchar(5)

) 

RETURNS @RtnValue table

(

 Id int identity(1,1),

 SearchValues varchar(500)

)

AS 

BEGIN

 Declare @Cnt int

 Set @Cnt = 1

 While (Charindex(@Delimiter,@StringIn)>0)

 Begin

  Insert Into @RtnValue (SearchValues)

  Select SearchValues = ltrim(rtrim(Substring(@StringIn,1,Charindex(@Delimiter,@StringIn)-1)))

  Set @StringIn = Substring(@StringIn,Charindex(@Delimiter,@StringIn)+1,len(@StringIn))

  Set...

It's probably something to do with your connection string, the easiest way to find out what it should be is to create a new Access Project with existing data and...

If you use the Value function in a new column, then you can sort on that column and end up with the desired results

Please bear in mind that you do have to run the snapshot if you need to initialise new subscribers

select city_code, outlet_codefrom ......

where convert(datetime,delete_date,1) > '20070101'