declare @month table(months varchar(30))

declare @date1 datetime

declare @date2 datetime

set @date1='10/1/2011'

set @date2='9/1/2010'

declare @year1 int

declare @year2 int

set @year1= year(@date1)

set @year2= year(@date2)

declare @month1 int

declare @month2 int

set @month1=month(@date1)

set @month2=month(@date2)

declare @count int

declare @monthname datetime

if (@year1<>@year2)

begin...

Can you paste the error?

Not Sure what you mean..but I hope this helps

Once you have added other Servers to Server A as linked server. you can use the four part name to reference any...

Sometimes the servername does not show up in the list...not sure why... but when you type the name of the Server manually and then add it, it does connect and...

Hi,

There is also a software called DotDefender which can be used as well

http://applicure.com/?page=dotDefender

Hi Also make sure that the guest user is assigned restrictive permissions. Explicitly denying permissions on the system tables can help reduce some impact. I have faced the SQL Injection...

Did u check the account under which the SQLServerAgent is trying to run?

There might be a better way of writing this query... But you can use this one and maybe modify this further..

declare @dbname table (dbid int,db varchar(300))

--the insert statement inserts...

I understand your question is to find the database and log files.

You can try this:

use [database_name]

select * from sys.database_files

hi,

this was the kb article i referred to when i encountered the problem :

http://support.microsoft.com/kb/907739

Hi,

Have you registered a sql server 2000 instance in sql server 2005 and are trying to edit the properties of that instance. I have encountered a similar problem when...

hi grasshopper,

I am still new to SQL 2005 but I try and help as much as i can. It was just an attempt to help you.. 🙂

http://www.sqlservercentral.com/Forums/Topic431723-146-1.aspx

See if the below link helps..I have been using this extended stored procedure for a long time and it has been working great. It uses SMTP too..

http://www.sqldev.net/xp/xpsmtp.htm

when you use datepart and dw as the argument, it returns the weekday as integer value. where

Sunday=1 and Saturday=7 as mentioned in BOL. I hope the below query helps.

Declare @mydate...