Viewing 15 posts - 42,151 through 42,165 (of 49,562 total)
Lee From Bangalore (12/23/2008)
While taking the backup if the database is currupted what will we do?
Depending on the severity, fix the corruption, or restore a clean backup.
December 24, 2008 at 1:11 am
Save as a .sqlplan file, zip and attach to the post.
December 23, 2008 at 11:43 pm
Check in Books Online, under sys,dm_exec_sql_text. There are examples there.
December 23, 2008 at 11:41 pm
Grant Fritchey (12/22/2008)
Gail Shaw had some interesting sample code around COUNT methods in her SQL Pass Presentation. It might be on her blog.
Or it might not. At least right at...
December 23, 2008 at 10:57 am
What is this supposed to do?
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 23, 2008 at 10:35 am
None. The TS exam is a prerequisite for the two ITPs, but that's it.
This site should answer all of your certification questions - http://www.microsoft.com/learning/mcp/certifications.mspx
December 23, 2008 at 10:30 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/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
Viewing 15 posts - 42,151 through 42,165 (of 49,562 total)