Thanks, this is exactly it. The environment...

mandoswork (8/1/2012)

---

Can anyone tell me why the script below is returning "Msg 102, Level 15, State 1, Line 1

Incorrect syntax near ')'." when I try and execute? It compiles OK...

I know nothing about Powershell, but the SQL command you need is:

SELECT suser_sname(owner_sid)

FROM sys.databases d

WHERE d.name = 'DBNAME'

-- OR d.database_id = 'DB_ID';

Use Powershell to execute this command, swapping out DBNAME...

I am simply looking for ideas or thoughts from people who have done something similar. Once current proposal is to take the SQL data at its previous state before it...

Ooooooo....

I think if I found one of my developers using SMO to access database objects directly, that person would be found hanging from a cross in the morning.

This situation is...

Sorry Abel but this is god-awful advice. I recently got involved in a round of recruitment...

I would certainly get rid of the SELECT * and replace it with discrete column names.

This should simultaneously make it easier to profile/trace the query and map against performance, whilst...

* Is it better (performancewise and moneywise) to upgrade to a higher vesrion of SQL, so that we can also upgrade to more processors and memory; or is it better...

Be very, very careful with FOR LOGON triggers. If you take the first script in this thread as an example, it'll work fine but should anything happen to the...

I think this should do it:

DECLARE @n INT

SET @n = 1

WHILE @n <=31

BEGIN

SELECT ID, purchase_id, supp_add_mat_id,

mat_code,asset_no,

CASE WHEN DATEPART(dd, require_date) = @n THEN qty ELSE '0' END AS qty,

require_by,require_date,require_desc,

status,pr_detail_asset,scheduled

FROM dbo.t_pr_details

SET...

What I look for is a challenge. My last employer, though the people were warm and friendly and the environment was OK, was in the managed services business -...

The problem is, it's all relative and totally subjective. There's too many factors affecting the bell(end?) curve, from how you and your job is perceived through to your social...

You could insert the data directly to a staging table on production. This does carry an injection risk but if you are validating your data application-side, this risk is...

ashish.sys (7/18/2012)

---

Pls Explain

------------------------------------------------------------------------------

;WITH Cte AS

(

SELECT

ClaimNO,

CAST('<M>' + REPLACE( REPLACE(...

Marvellous, thanks Grant.