Viewing 15 posts - 6,601 through 6,615 (of 7,253 total)
So there is the problem.
I didn't encounter such a situation yet.
What's the sql-version/sp / hf ?
November 24, 2004 at 12:07 am
Did you run the @Cmd in a cmd-box for test ?
I guess it gives a popup at serverside
November 23, 2004 at 8:23 am
Is this what you're looking for ?
I prefer using Left outerjoins because I find them to be more readable.
I also like using objectaliases...
November 23, 2004 at 6:09 am
your problem object :
select object_name(71577680)
Your problem index :
Declare @Name varchar(128)
select @Name = object_name(71577680)
exec sp_helpindex @Objname = @Name
I would run :
DBCC CHECKDB ( 'yourdb') WITH ALL_ERRORMSGS
check BOL for...
November 23, 2004 at 12:23 am
there are # of ways to do this. This is one of them :
how about : (#tmp1 is your table)
create table #tmp1 (id...
November 19, 2004 at 1:49 pm
I switch all db's to "bulk logged" in the first step of the maintenance job (dbreindex/indexdefrag).
then perform maintenance
then switch back to "full" when needed
November 19, 2004 at 1:33 pm
'create date last month...' can be when you alter the table e.g. using EM. It has the tendency to use a ddl sequence of rename - create - insert -...
November 19, 2004 at 1:29 pm
that way your usp_ only returns a value.
use raiserror of you want to have an error raised and set the jobstep's "on error" action to "quit job with failure"
Check BOL.
e.g....
November 19, 2004 at 1:22 pm
SQL2005 ? or wrong forumgroup ?
SQL2000 : make sure your sqlserver / sqlagent serviceaccout has got the needed authority for your network-shares.
This job...
November 19, 2004 at 2:26 am
Try to alias the tables and you'll find your problem easy so solve.
select MyAlias.mycol,...
from myschema.myverymeaninglesstablenamefartolongtoread MyAlias
...
if you still cannot find it, post...
November 19, 2004 at 12:53 am
how about using a udf ?
read : http://www.sqlservercentral.com/scripts/contributions/592.asp
November 18, 2004 at 5:14 am
I also backup master and msdb everytime a scheduled backup is taken (full/diff/log) of any userdb.
November 17, 2004 at 11:53 pm
Can you force a table-scan on all tables of your db ?
select * from yourtable
Why : so no indexes (except clusterd) are used and only datapages are accessed. This way you...
November 17, 2004 at 1:59 pm
BACKUP DATABASE [master] TO DISK = N'\\ribackupsrv\BACKUP\masterfull.bak' WITH INIT , NOUNLOAD , NAME = N'master full backup', SKIP , STATS = 10, NOFORMAT
BACKUP DATABASE [model] TO DISK = N'\\ribackupsrv\BACKUP\modelfull.bak' WITH ...
November 17, 2004 at 1:45 pm
early in the morning
it just scripts the non sql7 stuff and haves you run into the...
November 17, 2004 at 2:59 am
Viewing 15 posts - 6,601 through 6,615 (of 7,253 total)