Viewing 15 posts - 9,406 through 9,420 (of 13,469 total)
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...
May 21, 2010 at 7:37 am
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...
May 21, 2010 at 6:41 am
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...
May 21, 2010 at 6:26 am
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...
May 21, 2010 at 6:22 am
duplicate post, do not reply to this thread.
continue the discussion here
May 21, 2010 at 6:17 am
anjani_aim (5/21/2010)
May 21, 2010 at 6:07 am
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...
May 21, 2010 at 5:38 am
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...
May 21, 2010 at 4:55 am
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...
May 20, 2010 at 7:28 pm
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)...
May 20, 2010 at 12:17 pm
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...
May 20, 2010 at 11:43 am
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...
May 20, 2010 at 11:25 am
--results
Acct TransDesc Date ...
May 20, 2010 at 11:21 am
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...
May 20, 2010 at 10:50 am
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...
May 20, 2010 at 9:56 am
Viewing 15 posts - 9,406 through 9,420 (of 13,469 total)