Viewing 15 posts - 5,821 through 5,835 (of 7,429 total)
Change this
SELECT tbl_index = @GRANT + ' ' + 'select, execute ON'+ ' ' + name + ' ' +
to
SELECT tbl_index = @GRANT + ' ' + ' execute ON'+...
May 17, 2002 at 10:14 am
Memory is allocated when a variable is declared and the data is altered when it is set.
"Don't roll your eyes at me. I will tape them in place." (Teacher on...
May 17, 2002 at 10:04 am
Sorry I cannot think of anything ese offhand. Will post if I do though.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 17, 2002 at 9:34 am
Based on your error it looks like sp_grant_revoke tried to revoke select permissions on sp_grant_revoke_perms_roles which SPs do not have a Select permission.
"Don't roll your eyes at me. I will...
May 17, 2002 at 9:05 am
Just a thought, does this table have a trigger on it?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 17, 2002 at 8:45 am
Check out this article by Steve http://www.sqlservercentral.com/columnists/sjones/recoverthosepackages.asp
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 17, 2002 at 8:41 am
Ok are you saying you need to duplicate a database for testing and you have already done this? However, you need to have a different person to have access to...
May 17, 2002 at 6:15 am
What ADO object Library are you using and have you tried to install the current MDAC to see if this makes a difference. I see no issue with the code...
May 17, 2002 at 6:02 am
Oops just found this, should help get the info. At http://buku.ti.itb.ac.id/SQL-Server/ch15.htm#Heading11
quote:
To load or recover a database from a backup, the actual device...
May 17, 2002 at 5:41 am
WHen you create your DB you must not only the fiole size but the device fragment allocations. Ex.
I create a 100 MB database and 25MB Transaction log.
Then as I near...
May 17, 2002 at 5:39 am
1) FOr the most part no, at least not like we should here. I comment my code and make script copied of the DBs but not all the developers here...
May 17, 2002 at 5:11 am
As far as where it exists as long as you can reach the machine by way of TCP/IP and talk to the port SQL is on the it is just...
May 17, 2002 at 4:48 am
If you do not have any data in this table then delete it and rebuild it to see if fixes. If you do then create a new table with the...
May 17, 2002 at 4:45 am
First off depends on the version of SQL and hom many clients you will have to get the best pricing. The best place to look thou is here http://www.microsoft.com/sql/howtobuy/production.asp for...
May 17, 2002 at 4:31 am
Are you doing this in EM or other. Use Profiler to trace the statement to see what is suubmitted to make sure you are delivered good data.
"Don't roll your eyes...
May 16, 2002 at 8:12 pm
Viewing 15 posts - 5,821 through 5,835 (of 7,429 total)