Viewing 15 posts - 16 through 30 (of 62 total)
It depends to what degree you're required / need to enforce the issue. As long as the account isn't a valid login within SQL or the BUILTIN\Administrators group doesn't...
October 16, 2012 at 11:34 am
The query will work simply by removing the "sys." from sysprocesses. master..sysprocesses exists in SQL 2000.
September 24, 2012 at 1:32 pm
In SSMS expand the database and table that you want and drag the column folder of the table you want to query into the query window. it will list...
August 28, 2012 at 7:48 am
If all they need is execute to a single procedure. Grant connect to the database and grant execute to the specific stored procedure.
August 6, 2012 at 8:18 am
The little red arrow indicates that the job has been disabled. You can right-click on the job in SSMS and you should see the option to ENABLE the job.
June 18, 2012 at 12:45 pm
Place [] around the database name.
June 12, 2012 at 8:51 am
If the 2005 instance wasn't an in-place upgrade but a fresh install you'll still need to copy the logins from 2000 instance to the 2005 instance. Instances on the...
April 23, 2012 at 2:34 pm
Public is default database role that all users are a member of. GRANT EXECUTE on [PROC_NAME] to PUBLIC. The result is that every user of the database and...
April 16, 2012 at 2:51 pm
The easiest way would be to grant execute to public for this procedure. Otherwise you'll have to list every group or login in the grant statement.
April 16, 2012 at 9:47 am
I have a stored procedure that utilizes the xp_fixeddrives extended stored proc that gives you the ability to set both a percentage and fixed free space amount in which to...
February 16, 2012 at 2:19 pm
This issue is most liley related to the cursor against sysdatabases. Change the cursor to a static cursor and it should resolve the problem.(CURSOR STATIC FOR SELECT). Also...
February 15, 2012 at 6:19 am
So I'm a "deadwood" because I'm fortunate enough to be able to make the conference 🙂 1st trip in 15 years, so I'm looking forward to it.
January 24, 2012 at 12:20 pm
I'm happy to say that I have approval to attend and have already booked the arrangements. Looking forward to a great conference.
January 24, 2012 at 11:14 am
If scenario B is a striped volume of the 2 SSD drives, SQL would fail to recover. The volume(both drives) containing tempdb is no longer valid. You'd have...
January 23, 2012 at 1:02 pm
RESTORE DATABASE ControlDB FROM DISK = 'I:\CTLDB_backup_201201190927.bak' WITH
MOVE 'ControlDB' TO 'D:\SQLServer\Data\ControlDB.mdf',
MOVE 'ControlDB_log' TO 'D:\SQLServer\Log\ControlDB.ldf', REPLACE
January 19, 2012 at 7:45 am
Viewing 15 posts - 16 through 30 (of 62 total)