Cluster Analysis

Technical Article

RE: Populating @Variables dynamically

  • Reply

Farrel,No worries mate. Don't forget though: If you declare the variable within an sql string and exec it, it will generate a new spid and the variable will only have the lifespan of the new spid. It won't be useable anywhere else in your sproc - thats when you get the variable declaration error messages. […]

You rated this post out of 5. Change rating

2004-11-10

Technical Article

SQLserver agent Job doesnt work

  • Topic

HiI have made a packages that works nice when I execute the package but when I am doing a schedule job then doesnt it work.This is the error code:"The process could not be created for step 1 of job 0xB4B1D2612F8DC04194B919CFBE45923A (reason: The system cannot find the file specified).  The step failed." I have tried to change […]

You rated this post out of 5. Change rating

2004-07-07

Technical Article

RE: Why cant I expand the databases folder in EM?

  • Reply

I am using sql authentication. I have been working with the dba that set up the database for me and he says nothing has been altered with my permissions. He also examined the connection states as I was attempting to expand the folder and determined that my connection was NOT in a wait state. I am […]

You rated this post out of 5. Change rating

2004-07-01

Blogs

Back to Boston for SQL Saturday

By

I’m leaving again tomorrow for a trip. This time I head back to Boston...

T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?

By

Most of us who work with data have, at least a few times, been...

The Future of the Social Web Is in Good Hands

By

The Social Web Foundation is aiming to grow the fediverse and make the social...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers