Viewing 15 posts - 586 through 600 (of 1,186 total)
I would check the options right before you run the package that says do you want to save or just run now...... and NOT save the package
January 13, 2005 at 3:24 pm
I guess that the following may help
January 13, 2005 at 10:30 am
What are you trying to do when you get this error? It looks like a permissions problem when saving the package????
January 13, 2005 at 10:26 am
That is a good idea. However, WHY are they rebooting your servers to begin with? IF these are "yours" I would think that you should be involved anytime they need...
January 13, 2005 at 10:24 am
Is SQL Agent set-up as a local account or Domain account? I think it has to be set-up with a domain account to be able to use the SQL mail...
January 13, 2005 at 5:58 am
Didnt see the 2nd posting here so....
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=92&messageid=155279
January 13, 2005 at 5:52 am
Don't know if you have been here but BOL has this in the index
extended stored procedures, adding
January 13, 2005 at 5:51 am
BOL and read various different books that have been cited here in the past. Visit your local bookstore and look at the SQL books have a seat start reading and...
January 12, 2005 at 5:54 am
Start with BOL SQL Profiler, performance considerations
also check out http://www.microsoft.com/technet/community/chats/trans/sql/sql0924.mspx
Scarily enough Brian Knight (don't know who he is) is cited..... ![]()
January 11, 2005 at 1:03 pm
Why not simply use the power of SQL 2K to perform this for you i.e.
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblTest]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table...
January 11, 2005 at 12:51 pm
Domain account is the way to go. This way you don't have to worry about "@W*&#*$&*#Y my server just crashed NOW I have to recreate everything on my NEW server,...
January 11, 2005 at 5:23 am
You may want to check this link out
http://support.microsoft.com/default.aspx?scid=KB%3BEN-US%3BQ301413
Or
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q274383&ID=kb%3Ben-us%3BQ274383
http://support.microsoft.com really does come in handy sometimes
January 11, 2005 at 5:19 am
OW! Instead of COUNT(*) FROM you could look at something similar to what MS does for DROP/CREATE OBJECTS..
IF EXISTS (SELECT * FROM.. WITH 3 variables, then 2, etc...
This will evaluate...
January 8, 2005 at 4:13 am
Why not research using IF (SELECT COUNT(*) with 3 variables) <> 0 BEGIN END ELSE IF .... ???
January 7, 2005 at 4:59 pm
1. Contact Veritas. You should have a support agreement with them that covers you.
2. Contact Microsoft. I believe support RE: Service Packs/Hot Fixes is generally free.
3. Have you tried uninstalling...
January 7, 2005 at 5:19 am
Viewing 15 posts - 586 through 600 (of 1,186 total)