ahthomas (1/2/2013)

---

I have a script that writes data to a temp table. I need to automatically export this to a csv located at a UNC destination. How do I write...

ahthomas (1/2/2013)

---

I have a script that writes data to a temp table. I need to automatically export this to a csv located at a UNC destination. How do I write...

SQLCrazyCertified (12/31/2012)

---

Hi Lowell,

I don't exactly follow all the steps you mentioned above.

Can you please provide step by step for example, I want to create a

Linkedserver from SQL to Oracle.

What...

my original link in the other article is still good, as well...

arnipetursson (12/28/2012)

---

If you have default trace records from around the time of the delete, you may be able to compile a list of suspects. Hopefully you do not too...

the key is what criteria to use to find that 1200, or whatever the number actually is;

Create table dbo.UFM_AGENTS (

TS_ID ...

your trigger needs to refer to a table, just like any other SELECT statement does;

when inside a trigger, you need to use the virtual tables INSERTED or DELETED, depending on...

i have no problem doing this in either SSMS or Visual Studio; for me it's very common for documentation and help files to be included.

you just right click on the...

I think the issue is SSMS itself tends to require higher level permissions than you'd think would be required. if you access SMO directly(like from powershell) , ddl_admin or even...

reminds me of horrors like this:

CREATE TABLE [SELECT]([SELECT] INT IDENTITY(1,1) NOT NULL PRIMARY KEY )

SELECT [SELECT].[SELECT] FROM [SELECT] WHERE [SELECT] = 1

this is typically how i do it.

1. do a full backup, just in case.

2. SELECT the rows that in theory, should be affected...we might get a specific row count...

Shadab Shah (12/21/2012)

---

Al right .But they are totally different object . I mean to say one is a table and another SP. So that means you are saying that i...

That is an expected error that you will get used to once you get started with SQL.

object names must be unique, otherwise the system cannot map your queries to the...

wow, thats going to be tough;

the only thing i could think of was a combination of opc.three's example, and joining it against a list of common suffixes to find potential...

I've seen that situation where they are using CHAR(160) , which is a fixed width character that *looks* like a space, but isn't a REAL space (CHAR(32))

if you use that,...