And now he is getting...

asranantha (4/11/2012)

---

everything is avilable in google.at this time why maintaing this site.if any ;body know .simply sameif u know anserr tell why give this type of discussion.if u give...

asranantha (4/11/2012)

---

if u know answers plz tell me .other wise donot reply.

iam waiting for answrers.donot write any othere messages.if u know tell me properly other wise stop write any...

Okay, who has the silver spoon...

nick.fairway (4/11/2012)

---

Even more efficient for the test data supplied is this one - almost 9 times faster than the original -- look at the execution plan of the batch when...

This is what I came up with:

select replace(replace(replace(convert(varchar(30), getdate(), 120),'-',''),':',''),' ','')

You need to investigate the queries being run in the other database. If they are blocking queries in the database being accessed by the web app, it sounds like...

nick.fairway (4/11/2012)

---

A much more efficient version of this takes about 1/6 of the processing:

SELECT G.OrderDate, G.ProductKey, QtyOrdered = SUM(F.QtyOrdered), G.MTD

FROM

(

SELECT

...

yes, it is possible to generate a string that when displayed is a hyperlink.

jfogel-1131029 (4/11/2012)

---

I typically take 3-4 minutes to have a cig. I'm also here after hours, weekends and doing whatever it takes to get it done. For that alone I couldn't...

Hope this helps:

CREATE LOGIN [domainname\username] FROM WINDOWS; -- Replace domainname\username with the windows login you created

GO

USE [first_database_name]

GO

CREATE USER username FOR [domainname\username];

GO

EXEC sp_addrolemember N'db_owner', N'username'

GO

USE [second_database_name]

GO

CREATE USER username FOR [domainname\username];

GO

EXEC sp_addrolemember...

You have a GO (batch terminator in SSMS) in the middle of the IF ELSE.

IF EXISTS(SELECT name FROM msdb.dbo.sysoperators where name = @onCall)

EXEC msdb.dbo.sp_update_operator @name=@onCall,

@enabled=1,

@weekday_pager_start_time=0,

@weekday_pager_end_time=235959,

@saturday_pager_start_time=0,

@saturday_pager_end_time=235959,...

djustice 20821 (4/11/2012)

---

They need access to 2 databases, 'Test' and 'Production', but they need full access to both. By full access I mean they need to be able to...

Actually, I would be amazed if the coded posted actually did anything.

Duplicate post. Please post any answers here.