Hi,

I had the same problem with backup of transaction log so i created a table in the system table and created a trigger when ever why job finished a log...

Thanx ,

I think i have to stop here because every one says shrink shrink.

Hey, i can do shrinking logfile i tried on my test server on which 20 implementer are...

Thanx ,

I think i have to stop here because every one says shrink shrink.

Hey, i can do shrinking logfile i tried on my test server on which 20 implementer are...

Hi,

As i mentioned before u can use DTS Package to transfer ur jobs from one server to other.

DTS services--->new package ---> select tranfer job task.--->property window will diplay to u...

Hi,

Always finding diffrent ways to do.

The one i know is restore the system databases on other server.

or use DTS services to tranfer jobs.

need...

hi,

are u passing ur query in a veriable if

then pls check the variable datatype length.

if this doesnt helps pls sorry

sufian

Hi,

Sorry for late reply

TO start Sql agent in yukon u can do it in the same way in sql 2000 u do.

If u are not getting the option to...

Dear ,

Try using sp_who stored procedure u will get the information about login name and hostname from where it is coming.

sorry if it doesnt helps.

sufian

Mr.Phill Carter,

Thanx for suggesting to read BOI.But i suggest u that before replying any question first read it carefully then reply.Ok

If i had asked the question then i might have...

Thanx for all ur replies.

But i want that u all should have a good  look at the question again.

I havent asked for shrinks.

Have u all tried shrinking a logfile on...

Hi,

Nice to see ur reply.But can u tell me how many log files by default sql server create for a database.

can u pls tell me how to set delete files...

Hi,

There r many ways to remove the null from the tables when u execute sql statement .

If u want to see the records or insert then u can use something...

Thanx Steve

I think and will try to give the whole path .

But i think MS-SQL is much intelligent because when microsoft creates a extended stored procedure it also creates the...

HI,

asallam faiz,

Tnsnames.ora is a connection storage file.In this file u have to define the oracle database name (sid),Portno by default 1521 , then protocol if u run oracle on windows...

hi,

As i mentioned before this is the error i am getting can u pls answer for this why this error is diplayed.

I dont need any restore script.

'msmdarch' is not recognized...