Viewing 15 posts - 31 through 45 (of 108 total)
i did a testing, the script should work fine. So it may related with your table configuration, can you post your really error message?
create table autoorders
(
[AccountNo] varchar(10),
[SerialNo]...
August 2, 2012 at 2:53 am
clieck the job and view history, then post this info here.
August 2, 2012 at 2:40 am
how about this?
declare @test1 table(
id int,
val varchar(20),
ser int,
sa int
)
insert into @test1
select 1,'rer',1,Null union all
select 2,'rer1',Null,Null union all
select 3,'',Null,Null
select * from...
August 1, 2012 at 7:00 am
Backup of the principal database is allowed,so backup should not be the problem. You need to check windows event log and sql server errorlog and see anymore error is logged.
July 24, 2012 at 11:07 pm
Suppose you use webserver connecting to DB Server.
Then you could create alias on Webserver and using it in DB connection string(SQL Server Configuration Manager->SQL Native Client->Aliases).
After the primary...
July 24, 2012 at 10:41 pm
You can Configuring SSIS Logging and keep these information in sysssislog table. Then query this table when you run report.
sysssislog could show following information:id , event , computer ,...
July 24, 2012 at 9:55 pm
Do you have permission to access table on link2mas90?
July 24, 2012 at 3:25 am
try sp_refreshview after you update table schema. In addtion, you could use SCHEMABINDING when you create the view. Binds the view to the schema of the underlying table or...
July 24, 2012 at 3:20 am
you can try Database Audit Specification and Server Audit Specification.
July 24, 2012 at 3:16 am
Have you checked the excution plan for that particular SPID you just killed? I have the same problem before and it caused by index missing. After i add the index...
July 24, 2012 at 3:11 am
It seems the trigger failed to complete becuase of permission issue. By the way, do you have permission to alter index?
July 24, 2012 at 3:07 am
The stored procedure sp_help_revlogin could do this, refer to following article:
July 24, 2012 at 3:03 am
Thank you for posting the article.I have encountered a problem before. Changed the base table column data type, but the view didn't changed accordingly. So need to manually refresh the...
July 10, 2012 at 7:15 pm
Is it the log file large or data file large? If log file large and you want to shrink the file, you could modify to simple recovery mode.
July 5, 2012 at 3:00 am
You may need to clear the buffer cache and let it re-generate excution plan. Or you could try query hint.
July 5, 2012 at 2:53 am
Viewing 15 posts - 31 through 45 (of 108 total)