Viewing 15 posts - 31 through 45 (of 53 total)
| You can create a diagram, this is more visual. |
January 12, 2005 at 10:32 am
In EM go to server properties and under connections tab type in query time-out field 0, that means unlimited
October 11, 2004 at 7:14 am
| Applied same critical updates on many servers, including second instance in the cluster, where the first instance only having this problem with... |
August 16, 2004 at 10:24 am
Sorry, too fast reply: alter table orders drop column id_order alter table orders add id_order int not null Identity(1,1) |
July 14, 2004 at 12:42 pm
Run this:
alter table orders drop column id_order alter table orders alter column id_order int not null Identity(1,1)
|
July 14, 2004 at 12:40 pm
It works, I did it many times
SELECT * FROM OpenQuery (Linked_Server2, 'select * from pubs.dbo.authors (NOLOCK)')
July 8, 2004 at 1:23 pm
there was a good stored proc on this site awhile ago, don't remember the author:
CREATE procedure usp_failed_jobs_report
as
-- This SQL Code reports job/step failures based on a data and time...
July 8, 2004 at 1:10 pm
July 8, 2004 at 12:08 pm
I think in Query Analyzer you can use OpenQuery function, like this:
select * from OpenQuery(<linked server name>, 'select * from <tablename>')
July 8, 2004 at 12:00 pm
| Double check in EM whether dbo is the table owner or user. When you create the new table you lost not... |
June 25, 2004 at 8:23 am
I use the following stored procedure for monthly rename of any reporting tables: CREATE PROCEDURE sp_monthly_rename AS begin declare @newname varchar(55) set nocount on select @newname... |
June 23, 2004 at 8:38 am
| That way you can restore database that was backed up using the MS software (Tools>>backup ...). If you have an old... |
June 23, 2004 at 8:09 am
| Looks like you didn't install SQL agent from ArcServe. Just backup and restore only database files is not enough. |
June 22, 2004 at 1:28 pm
| Use db GO DBCC shrinkfile (db_Log1, notruncate) DBCC shrinkfile (db_Log1, truncateonly) Create table t1 (char1 char(4000)) GO Declare @i int Select @i = 0 While (1 = 1) BEGIN While... |
May 19, 2004 at 3:48 pm
Yes, I agree. I need a trigger with UDF that loops thru the attributes and returns a table with lot of... |
March 12, 2004 at 2:48 pm
Viewing 15 posts - 31 through 45 (of 53 total)