your right, I think it's permissions;

the account that SQL is running under, are you SURE it has access to the C:\Users\jwilliams\Documents\ folder and all it's sub folders?

since you've used CmdShell...

here's a screenshot to uninstall;

also, i believe if you go to the Surface Area Configuration, you can add yourself(windows login) as an administrator to your instance,a dn then change the...

if you can login with your windows login, it doesn't matter what the current password is for sa, just change it to a new, known password: you can rightclick>>Properties of...

select * from sys.all_objects where type_desc = 'SYSTEM_TABLE' --all sys tables

select * from sys.all_objects where type_desc = 'USER_TABLE' and is_ms_shipped = 0 --all user tables

aside from...

duplicate post, do not reply to this thread.

continue the discussion here

anjani_aim (5/21/2010)

---

I have 4 database with same structure. we have to integrate it into single database.All 4 database has same tables. there are some tables having identity key which have...

late binding of objects are a feature of stored procedures; you can reference a non existent table/view/procedure/function without raising an error. the references will be checked when the procedure is...

MC here's some basic steps; the first thing you need is access to an actual mail server , and the email/username/password used to login to the mail server; i believe...

you can create a job that starts when the sql agent starts; it's one of the options, after you create the job, to determine the schedule....there is a selection for...

i think this is what you might be after:

--results:

TheDomainTheUser

TheDomainlowell

declare @MyDomainLogin varchar(30)

SET @MyDomainLogin='TheDomain\lowell'

--SET @MyDomainlogin = SUSER_NAME()

SELECT

--the -1 and +1 are to remov ethe char '\' itself fromt eh results

SUBSTRING(@MyDomainLogin,1, CHARINDEX('\',@MyDomainLogin)...

great marty! glad it's working for you!

that FOR XML is great for concatenating, and the Tally Split is perfect for the opposite...getting a delimited list into rows.

Those two things...

multiply or add?

the DATEADD function can accept your start date and add x number of months to it to give you that future date, is that what you want?

select DATEADD(mm,14,'20090701...

--results

Acct TransDesc Date ...

no problem;the file name is being created with the UTC time (greenwich), so you must be in the US EST time zone to be -5 hours;

the times inside the backup...

i think you'll need a FOR XML to concat the colleges;

here's an example, i would have adapted it to your data if you included the CREATE TABLE and INSERT...