Viewing 15 posts - 42,166 through 42,180 (of 49,571 total)
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic624663-359-1.aspx
December 23, 2008 at 10:30 am
Just a heads-up. This is a copy of Tony's editorial for this week from Simple Talk - http://www.simple-talk.com/community/blogs/tony_davis/archive/2008/12/19/70941.aspx
Scott, is this reposted with permission?
December 23, 2008 at 10:23 am
beerampradeep (12/23/2008)
RESTORE cannot process database 'DATA_SAMPLE' because it is in use by this session. It is recommended that the master database be used...
December 23, 2008 at 10:18 am
From management studio, object explorer. Right click on the database, select Tasks, then Generate Scripts.
December 23, 2008 at 10:16 am
ps (12/23/2008)
create trigger trg_MyTrigger on myTableAfter Insert
AS
Declare @cardType as varchar(100)
Declare @devid-2 as varchar(100)
select @cardType=column1, @devid-2=column2 from inserted
exec HeadCountDetail @cardType, @devid-2
What's going to happen there if 3 rows are inserted...
December 23, 2008 at 4:57 am
santosh.lamane (12/23/2008)
FOR EACH ROW BEGIN
IF(NEW. coulmn1>2 AND NEW. coulmn1 < 4 ) begin
...
December 23, 2008 at 4:55 am
sayfrend (12/22/2008)
Ninja.People who ask question here in this forum are not as intelligent as you... please spare others.
Intelligence isn't in question here. Laziness is.
"I'm too lazy to read the...
December 23, 2008 at 4:49 am
CREATE PROCEDURE < Procedure Name >
AS
< Put query here >
Look up CREATE PROCEDURE in Books Online.
December 23, 2008 at 4:46 am
sashikanta.mishra (12/23/2008)
But in Oracle there is a table which traces last 1000 queries fired on the same database.
That's Oracle.
Can i get any kind of info from .LDF files
You can...
December 23, 2008 at 4:43 am
Bilichi (12/22/2008)
Replication is configured in Production only and not in my Development server.
Since that's a backup of a database that's replicated, there's replication set up in it as well. Create...
December 23, 2008 at 1:07 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic624449-5-1.aspx
December 23, 2008 at 1:05 am
jmohan_it (12/23/2008)
Any one can tell. what ia a breakpoint in ssis? How is it setup? How do you disable?
Have you looked through Books Online, specifically the sections on SSIS?
December 23, 2008 at 1:03 am
Not without a trace running. (profiler/server-side)
December 23, 2008 at 1:02 am
Someone's enable the query governor on the database, and set the threshold for 300. Speak to the DBA who looks after that server.
December 23, 2008 at 1:01 am
leonp (12/22/2008)
I meant to say I am seeing a lot of sessions with a 100% writer thread stats for this DB
Doesn't mean you have IO bottlenecks on the database server....
December 23, 2008 at 12:54 am
Viewing 15 posts - 42,166 through 42,180 (of 49,571 total)