Brandie Tarvin (2/14/2013)

---

Does Ask SSC require a different user login than SSC? I'm logged in here, but it won't let me post an answer to someone else's question without logging...

Run setup again, it is the only way to install a new server (instance)

Also available...

SQL browser started and listening on 1434.

Can you give more detail?

What do you mean by all job script?

Scripts to create all jobs?

The scripts jobs execute?

run the installer and when it askes to give your server a name, give it a different name than SQLEXPRESS

Its per database so you will need to run it in every DB.

Also sql_modules stores the definition for

P = SQL Stored Procedure

RF = Replication-filter-procedure

V = View

TR = SQL DML trigger

FN...

get the correct permissions to invoke RPC calls

select * from sys.sql_modules where definition like '%declare cursor%'

also why cursors and not set based operations?

Then going back to the first post in the other topic, start SQL in single user mode, ensure your a local admin on the windows box and add a new...

Is this topic, releated to this topic http://www.sqlservercentral.com/Forums/Topic1419820-391-1.aspx? If so dont cross post.

15151 means login doesnt exist or you dont have permission.

Go seek permission from a higher power who...

Have you read the userguide?

mitch.fh (2/14/2013)

---

Hi anthony,

This just seems to be the description of the user interface and how you can create/edit/delete cache-plans.

I didn't find anything here that tells you how to do it...

Just need to do an inner join from the tree CTE to the Produits table

CREATE TABLE [dbo].[CATEGORIES](

[ID_CATEGORIE] [int] IDENTITY(1,1) NOT NULL primary key,

[CAT_ID_PARENT] [int] NULL,

[CAT_DESIGNATION] [varchar](150) NOT NULL,

[CAT_LEVEL] [int] )

CREATE...

Does this help? Would just be a case of calling the job...

http://msdn.microsoft.com/en-us/library/ee636367%28v=sql.105%29.aspx