I am not sure why you want to modify DBAoncall group everyweek.  It is a permenent group and should have permenent member.  In our group DBAoncall read all the email...

My friend, what does that message box said I can't read french

mom

Also make sure that the login you use to execute the command has proper permission to create table, drop table ... and also read whatever is in P:\ dir.

mom

I used to see this kind of attack on the last company I worked for, what our network guy did was keep a log of what the suspect trying to...

bkelley,

Thank you. I found out from my team lead that we have agency wide client licensing so I didn't have to worry about this part of the cost, just...

bkelley,

I found chose licensing mode, window server, per seat but no number of seat... It does not have information about SQL Server license.

racosta,

SELECT serverproperty('LicenseType')--result is disable

SELECT serverproperty('NumLicenses') -- result...

You can not use CASE in this context. Case can only be use in the select statement but not the from section...

However you could try this way:

declare @db_nam varchar(40)

set...

CREATE PROC MyProc (

@MyVal int --My max value is 32767

) AS

--let's enforce your business rule here instead of on top level

if (@myval between 0 and 32767)

begin

...

DECLARE @status int, @message_id varchar(255)

-- SET @status = value would be here.

-- SET @message_id = value would be here.

EXEC @status = xp_findnextmsg @msg_id = @message_id OUTPUT

select @status -- if...

Jeremy,

You should be able to preview data in your DTS. Can you preview it to see it's that's all it is putting? sometime it think that the other...

I just use char(9) because it's easy for me to see when I bcp it out to text:) for your purpose use anything you like, It'll work just as greate.

mom

...

This is the possibility:

you are not the dbo of the database. You might just has db_owner role. You created the function under domain\username.udf_format_date

as well as create another function...

Have you though of

update data = REPLACE(data,' ',char(9))

select substring(data,CHARINDEX(char(9),data) ,len(data)) -- will give you the 2nd part of address you are looking for.

mom

How about try it this way

select date_effect,

case WHEN DateDiff(mm, License.date_effect, getdate()) > 4 then (License.basefee * 0.05)* (3)+ (License.basefee * 0.1))

when 1 THEN License.basefee * 0.1

ELSE (

(License.basefee *...

The only thing I could think of, is the fact that you have no space between each word so the final statement looks like

"Insert jobnames (JobID, ServerName, JobName)Select job_id...