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
Good Hunting!
AJ Ahrens
webmaster@kritter.net
January 13, 2005 at 3:24 pm
I guess that the following may help
Good Hunting!
AJ Ahrens
webmaster@kritter.net
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????
Good Hunting!
AJ Ahrens
webmaster@kritter.net
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...
Good Hunting!
AJ Ahrens
webmaster@kritter.net
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...
Good Hunting!
AJ Ahrens
webmaster@kritter.net
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
Good Hunting!
AJ Ahrens
webmaster@kritter.net
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
Good Hunting!
AJ Ahrens
webmaster@kritter.net
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...
Good Hunting!
AJ Ahrens
webmaster@kritter.net
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..... ![]()
Good Hunting!
AJ Ahrens
webmaster@kritter.net
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...
Good Hunting!
AJ Ahrens
webmaster@kritter.net
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,...
Good Hunting!
AJ Ahrens
webmaster@kritter.net
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
Good Hunting!
AJ Ahrens
webmaster@kritter.net
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...
Good Hunting!
AJ Ahrens
webmaster@kritter.net
January 8, 2005 at 4:13 am
Why not research using IF (SELECT COUNT(*) with 3 variables) <> 0 BEGIN END ELSE IF .... ???
Good Hunting!
AJ Ahrens
webmaster@kritter.net
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...
Good Hunting!
AJ Ahrens
webmaster@kritter.net
January 7, 2005 at 5:19 am
Viewing 15 posts - 586 through 600 (of 1,186 total)