Viewing 15 posts - 16 through 30 (of 164 total)
Another possibility is using SSRS (Reporting Services) and setup a subscription that emails the Excel file on a daily schedule.
September 19, 2011 at 12:51 pm
Can't remember if I've done this, but I think you can set up a linked server to the Excel spreadsheet and then setup a SQL Agent job to run that...
September 19, 2011 at 12:47 pm
Chrissy,
Take a look at this link:
You may need to access the server with an admin account and enable EXECUTE permission on the procedure in the master db for...
September 19, 2011 at 7:50 am
Also, does this work from your login?
declare @SmoRoot nvarchar(100)
exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\Setup', N'SQLPath', @SmoRoot OUTPUT
select @SmoRoot
September 16, 2011 at 3:00 pm
It looks like that command returns the location of your SQL Server installation, no matter the particular version you are using. But why you are getting this error when you...
September 16, 2011 at 2:58 pm
so one of the DBAs tried using EXEC master..sp_grantlogin 'mydomain\login' and this has fixed the problem.
I didn't setup the server or the logins, so I'm not sure exactly how it...
September 15, 2011 at 12:37 pm
Jared, I'll have to give that a shot. But first, I need to make sure I won't cause more problems by deleting and re-adding that login!
September 15, 2011 at 12:01 pm
Jared, the main dba in our group runs a script which re-maps any un-mapped logins to db users for all databases. I've seen a number of similar scripts here.
September 15, 2011 at 11:35 am
Jared, where would I look to check the domain permissions? That sounds promising, but the job is owned by the same user on production and is running ok. Thanks for...
September 15, 2011 at 11:15 am
Yup, everything's fine there, and same as on production box. Enabled property is set to true, but that's not the same as the HasAccess property, which is still false.
September 15, 2011 at 10:40 am
Maybe you should create an update procedure that takes a table-valued parameter. Then you could use a cursor or some other means to loop through the table values and create...
September 9, 2011 at 8:06 am
Well, I have a hunch it's related to the PGP whole disk encryption, but I haven't found much online about installing SQL Server on top of that. Maybe it's not...
September 8, 2011 at 12:00 pm
Only thing I can think of is to script it out. I sometimes find that scripting is faster and less of a pain than using the GUI.. sometimes!
September 8, 2011 at 11:34 am
**Update**
I detached the questionable database, stopped the sql server, copied the mdf and ldf files, renamed the old files, and used the new copies to re-attach the db.
Now everything's...
September 8, 2011 at 11:31 am
Suresh,
DBCC CHECKDB WITH TABLOCK gives me this error:
Msg 5030, Level 16, State 12, Line 1
The database could not be exclusively locked to perform the operation.
Msg 7926, Level 16, State...
September 8, 2011 at 7:18 am
Viewing 15 posts - 16 through 30 (of 164 total)