Viewing 15 posts - 481 through 495 (of 1,124 total)
SELECTi.Name, s.stat1, s.stat2, s.stat3, k.kpi1, k.kpi2, k.kpi3
FROMItems i
INNER JOIN
(
SELECTISNULL( s.IDItem, k.IDItem ) AS IDItem,
s.stat1, s.stat2, s.stat3, k.kpi1, k.kpi2, k.kpi3
FROM[STATISTICS] s
FULL OUTER JOIN KPIs k ON s.IDItem = k.IDItem...
February 18, 2009 at 8:12 am
What version your SQL Server 2005 is? Is it 32 or 64 bit? Database Mail is only supported on 32 bit versions of EE, DE, WE & SE editions.
Edit:
See...
February 18, 2009 at 7:48 am
Using "sa" Login
1. Click the Start button, point to All Programs, click Microsoft SQL Server 2005, and then click SQL Server Management Studio.
2. Connect to an instance of SQL...
February 18, 2009 at 7:42 am
Do the access db is password protected? If not then drop & create the linked server using the following script..
DECLARE @strLinkedServer NVARCHAR(100)
SELECT @strLinkedServer = 'SomeAccessServer'
EXECUTE master.dbo.sp_dropserver
@server =...
February 18, 2009 at 7:38 am
Can you able to execute the individual procedure TPRO.dbo.Data_Check_Notification_Procedure_SP successfully?
February 18, 2009 at 7:21 am
dave_282 (2/18/2009)
Could you please explain further how I go about doing that, Im afraid Im quite new to sql server. Or if I need to re-install, what I...
February 18, 2009 at 7:16 am
By default, users on Windows Vista that are members of the Windows Administrators group are not automatically granted permission to connect to SQL Server, and they are not automatically granted...
February 18, 2009 at 6:50 am
ashok (2/17/2009)
Hi friendThanks for yours reply. In which edition database mail is available??
Hope yours reply.
Regards
Ashok
Database Mail is supported on all 32 bit versions of Enterprise, Standard, Workgroup & Developer...
February 18, 2009 at 6:35 am
Derek Dongray (2/17/2009)
This is for SQLserver 2008. Are there equivalent procedures for SS2K5?Plus I'd also like an equivalent for sp_start_job.
I've taken the excerpt from SQL 2005 BOL, and are working...
February 18, 2009 at 6:19 am
How about this one?
DECLARE @tblObjects TABLE( ObjectID INT NOT NULL, ObjectStateID TINYINT NOT NULL, ObjectStateDateTime DATETIME NOT NULL )
INSERT@tblObjects( ObjectID, ObjectStateID, ObjectStateDateTime )
SELECT1, 1, '2009-02-17 17:38:51.393'
UNION ALL
SELECT1, 2, '2009-02-17...
February 17, 2009 at 5:24 am
raden (2/17/2009)
Thanks Ramesh.Can you point me to any sample code that creates a Job, kicks it off and then delete the job once the task is done?
Actually, I never had...
February 17, 2009 at 5:24 am
Assuming that you want to update status column with the output value of the variable @chStatus, then you have to do
EXEC dbo.Temp @chStatus OUTPUT
UPDATE @tb SET Status = @chStatus
If...
February 17, 2009 at 5:04 am
In most of the cases, NOT EXISTS performs better than NOT IN & LEFT JOIN. Can you post the NOT EXISTS query, currently you are using?
It should look similar...
February 17, 2009 at 2:03 am
Taken from Books Online:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/3b76545e-ad7d-4a05-8766-272546aeed2e.htm
How to: Create a SQL Server Agent Job (Transact-SQL)
This topic describes how to use stored procedures to create a Microsoft SQL Server Agent job.
To create a...
February 17, 2009 at 1:40 am
This should perform better than the previous one...
SELECTMachineName,
SUM( ( CASE WHEN EntryTime >= DATEADD( MINUTE, -1, GETDATE() ) THEN 1 ELSE...
February 17, 2009 at 1:31 am
Viewing 15 posts - 481 through 495 (of 1,124 total)