Viewing 15 posts - 5,416 through 5,430 (of 7,429 total)
Using EM to generate the scripts there are three tabs. The last one "options" has the items you are looking for under the "Security Setting Options" area.
"Don't roll your eyes...
June 17, 2002 at 6:13 am
Please do not cross post. See http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=4860&FORUM_ID=5&CAT_ID=1&Topic_Title=Database+Tuning+and+Maintainance&Forum_Title=Administration
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 17, 2002 at 6:07 am
Also when it says it did a dump check SQL Error Logs and Event Viewer. Should provide some extra info. Also if not in those, drill the Windows explorer to...
June 17, 2002 at 5:48 am
I have only played with the function a bit but could rarely get it to work. This may help a bit though
select object_name(p.id) as Object, c.[name], p.[name] as type, value...
June 17, 2002 at 5:44 am
TCP/IP has the least network overhead and can be implemented on any machine with IP installed. With named pipes you have to either have an LMHOST entry on each machine...
June 17, 2002 at 5:25 am
U R Welcome. Never worry you will always learn something or find you know the answer and still do it wrong. I love these forums as they are the best...
June 16, 2002 at 7:49 pm
Sorry no server in front of me but one of those fields is an ID field for the parent object attached to. Usually doing object_name(thatfield) will tell where from. Otherwise...
June 16, 2002 at 7:47 pm
Sorry to say you are going a little overboard here. A SELECT statement can be used to set multiple variables at one time without a cursor. It is a good...
June 16, 2002 at 6:43 pm
Can you post what you have tried so I can undestand what the logic is doing and give you a proper response? Either could be better and there may be...
June 16, 2002 at 2:50 pm
The easiest and fastest way is to use Enterprise Manager. Drill to the database and right click it. Then find script database and you can select the various items you...
June 16, 2002 at 8:27 am
Your best bet is to lock the record but this will cause a performance hit. You only other options are 1, have a timer recheck the data peridoically to verify...
June 16, 2002 at 8:23 am
Honestly it seems to me that SP2 on the Dev box should have been fine as you were moving forward in revision but SP1 could be a problem if you...
June 16, 2002 at 8:17 am
Are you going against a view or linked server and can you show us an example of one solution you tried?
"Don't roll your eyes at me. I will tape them...
June 16, 2002 at 8:14 am
Normally I would suggest create a composite index clustered on UniCol1, UniCol2, UniCol3 (your columns that should be unique) then add an IDENTITY column so you have a number reference....
June 15, 2002 at 7:53 pm
Check out http://support.microsoft.com/default.aspx?scid=kb;EN-US;q270119 it will show examples and offer trouble handling tips.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 15, 2002 at 7:37 pm
Viewing 15 posts - 5,416 through 5,430 (of 7,429 total)