Viewing 15 posts - 3,751 through 3,765 (of 7,429 total)
To verify the reason is permissions based or to get a more specific answer look at the window Event Viewer logs. There is usually more descriptive answer to the problem...
December 19, 2002 at 4:47 am
Just an additional comment here. I love triggers and use them often. However, I also have been moving more and more logic into Stored Procedures and away from the app...
December 19, 2002 at 4:43 am
Server Groups are logical orderings you create in EM. They are stored in the registry. ServerGroups reads only from the local machines registry where the application is run. So on...
December 19, 2002 at 4:36 am
Yes, using DTS you can process the file much easier and if you need to run every day you can schedule as a job thru SQL Agent which means you...
December 19, 2002 at 4:19 am
This should do it
quote:
Moving the Model DatabaseTo move the model database, SQL Server must be started with trace flag 3608...
December 18, 2002 at 8:14 pm
Depends on several factors but the key is once you start an exe or bat SQL will not retain control over in many cases. One method is to use xp_cmdshell...
December 18, 2002 at 8:11 pm
I do believe all it means is the connection was made but no type of query or SQL Sommand has been run yet. Once one occurrs you should see an...
December 18, 2002 at 10:13 am
Sorry, that is a different animal and I haven't had real time to experiment with it. I do believe you are on the right track thou, but I am not...
December 18, 2002 at 9:53 am
You cannot restore a transaction log backup to an in progress DB. You also have to restore like so. Last Full backup first with norecovery, then each Tl backup in...
December 18, 2002 at 9:32 am
Sorry in Enterprise Manager drill to the server you question, right click the server properties and look at Product Version this should match the @@version response you get but is...
December 18, 2002 at 9:19 am
Check out the first comment in this thread to see if maybe works in your case. http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=8864&FORUM_ID=48&CAT_ID=1&Topic_Title=MSDE+and+SP4&Forum_Title=Service+Packs
December 18, 2002 at 9:04 am
Unfortunately I don't have 95 installed anywhere. But MS has started dropping support for 95 on many other tiems and even working on dropping 98 at this point, they may...
December 18, 2002 at 5:23 am
No gotchas I am aware of but as for places else to look open EM drill to the server in Question and open Server properties. But you might also drill...
December 18, 2002 at 5:20 am
As long as you can place it within the Dynamic SQL and keep all in scope then yes. If not then you may need to create a #temp table which...
December 18, 2002 at 4:50 am
quote:
Antares, generated a VBScript to execute the process, and it worked successfully so far - I'll be keeping an eye on it...
December 18, 2002 at 4:47 am
Viewing 15 posts - 3,751 through 3,765 (of 7,429 total)