Hi,

hmm..I think the script from this topic didn't help you 🙂

What was the problem with it?

Regards

Hi,

please check the length of the string you are passing to the database.

If you have a table with a VARCHAR(10) field and pass the string '1234567891011' you get this error...

Hi,

with your datetime column you already have the age. If you want to display the age in days in a new column add it as a computed column with...

Hi,

I think with the search term "subquery" you'll find more examples.

Regards.

Hi,

I'm not sure if I understood your question correctly 🙂 but i'll give it a try.

create table tester

(

num int,

my char(1)

)

insert into tester values (1,'')

insert into tester...

Hi,

I just tried this out...

alter trigger tdTest on dbo.Test

FOR DELETE

AS

BEGIN

disable trigger tuTest on dbo.Test;

UPDATE test SET number = 10 where number2 = 1;

enable trigger tuTest on dbo.Test;

END

...and it works....

Hmm,

I think I would write a small tool which does the following.

1. read a list of the sql files with filename (assuming the filename is the name of the function/procedure)

2....

Hi,

you could use the osql tool (command prompt)

osql -S 192.168.1.13 -E -i sqlfile.sql

That's the command for one sql file (sqlfile.sql) with a trusted connection to 192.168.1.13. Then you just...

Hi,

just played around with your question...

With the script below you can check if a job finished xx minutes ago. You could use this script to set up a another job...

Thank you for your answer. Can you tell me where I can find such tools?