OK, this was not what it looked like at first glance...but there is somethign you need to know from the outset: SQL is declarative, not interpreted, so you cannot use...

Uripedes Pants (4/19/2012)

---

Hi all -

I'm very green in SSIS but I've been thrown into a major project and tasked with putting in some error handling. Specifally, I need to check...

The desire to use of an object name stored in a variable to build a query, e.g.

DECLARE @tableName SYSNAME;

SET @tableName = N'MyTable';

SELECT Column

FROM @tableName;

usually indicates a flawed design. Mind...

I just tested it out...you can add the user to model and put it in the db_owner Role and anytime a new DB is created the user will be there....

GilaMonster (4/19/2012)

---

That gets an...

You can retrieve the actual plan for your session, check out this article for next time:

Viewing the Execution Plan of a Running Query in SQL Server

Lynn Pettis (4/19/2012)

---

I do have to say I liked Oracle's CREATE OR REPLACE. If the database object (view, stored procedure, function) already existed, it replaced it and if it...

Tristan Chiappisi (4/19/2012)

---

Another thought to reduce the amount of rows was a key/xml table where the XML would contain a series of statistics metrics per store and I would just...

Which SSIS data type are you converting the string to?

See section "Mapping Integration Services Data Types to Database Data Types" on Integration Services Data Types to ensure you are using...

It is true that BEGIN / END adds clarity, but it does not release us from separating our batches with GO, i.e. this still produces an incorrect result:

use tempdb

go

create proc...

I am not sure how you would do this in one WMI query. I would setup two watchers in sequence...when the first watcher finds a file it will pass control...

HowardW (4/19/2012)

---

opc.three (4/19/2012)

---

itskanchanhere (4/19/2012)

---

I used Teradata SQL Assistant client to execute some procedures in SQL Server. Since these had Print statements they failed...Sps without print were successfully executed.. I faced...

USE database_name

DECLARE @sql NVARCHAR(MAX);

SET @sql = N'';

SELECT @sql = @sql + 'EXEC master.dbo.sp_help_revlogin @login_name = N''' + sp.name + ''';

'

FROM sys.database_principals dp

...

Get Back into SQL Server After You've Locked Yourself Out

itskanchanhere (4/19/2012)

---

I used Teradata SQL Assistant client to execute some procedures in SQL Server. Since these had Print statements they failed...Sps without print were successfully executed.. I faced problem only...