HI,

Have u checked that under what database ur job is scheduled.

Hope this helps u.

from

Killer

Hi ,

This one is really tough

I asked that i had tranferd a table in a table and i want to zip it.

i did it in 2 steps.

i used BCP utility...

Hi,

I am not sure what is happening with u  but if sql server workes fine in the office then ur DBA or Networkadmin had ristricted or defined permission.

Or it may...

Hi,

I am not sure what is happening with u  but if sql server workes fine in the office then ur DBA or Networkadmin had ristricted or defined permission.

Or it may...

Hi,

try this with no use name and password.

bcp X.dbo.Y" in c:\temp\test.txt -c

-q -t "$" -r -"" -T -S [servername\instancename] -U -P

this may help u

from

killer

HI,

That is  connection broken error()

from

killer

HI,

How can i set the Transaction save point or transaction name by default for a query. and for every user.

thanx for help

from

killer

Hi Sswords,

I rebooted the server manytimes.Nodody have right to access the EM except me.

Only problem in my sql server was that only which i described before.

I checked the NT Fibre...

Hi,

I had check the link given by ssword and checked the sp_configure on  my machine and find the same entries as given by microsoft on the website. My sql server is not...

Hi,

DBA what u want , ur new research on sql.

or u want to ask something else

from

killer

Hi Steve,

In error log the below information is given of which i have no idea.

[131] sql agent service is stopping due to a stop request from a user,process ,or the...

Hi pawan,

This error occurs basically on process locks.

Check the process locks and if u have dead locks on ur database kill the process. and rerun  ur code

from

killer

hi asad

http://www.windowsitpro.com/SQLServer/ Article/ArticleID/8231/8231.html

or read windows help for system level trace

from

kiler

Thanx Chris,

But i changed like this becasue in the code u posted have missing the sysobject so will not get the correct id for the table in syscolumns .

DECLARE @originalcolumns INT,@objectid...

Hi ,

Thanx  to neold it worked exactly what i needed.

Thanx to Remi,johnson and everybody on this post.

from

killer