Viewing 15 posts - 2,431 through 2,445 (of 6,395 total)
Run setup again, it is the only way to install a new server (instance)
February 14, 2013 at 4:18 am
WWDMark (2/14/2013)
Suresh B. (2/14/2013)
Must read "How to become an Exceptional DBA" by Brad McGeheeNot a bad read, here's a link to my copy of the ebook (pdf format): https://dl.dropbox.com/u/52486810/How_To_Become_An_Exceptional_DBA_Ebook.pdf
Also available...
February 14, 2013 at 4:14 am
SQL browser started and listening on 1434.
February 14, 2013 at 4:12 am
Can you give more detail?
What do you mean by all job script?
Scripts to create all jobs?
The scripts jobs execute?
February 14, 2013 at 3:52 am
run the installer and when it askes to give your server a name, give it a different name than SQLEXPRESS
February 14, 2013 at 3:52 am
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...
February 14, 2013 at 3:46 am
get the correct permissions to invoke RPC calls
February 14, 2013 at 3:26 am
select * from sys.sql_modules where definition like '%declare cursor%'
also why cursors and not set based operations?
February 14, 2013 at 3:25 am
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...
February 14, 2013 at 3:22 am
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...
February 14, 2013 at 3:00 am
Have you read the userguide?
February 14, 2013 at 2:45 am
mitch.fh (2/14/2013)
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...
February 14, 2013 at 2:29 am
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...
February 14, 2013 at 2:16 am
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
February 14, 2013 at 2:06 am
I thought the limit was 20 cores, not 16.
But if SQL can see 20 cores, but only use 16, you still need to licenses all 20 cores as it is...
February 14, 2013 at 1:50 am
Viewing 15 posts - 2,431 through 2,445 (of 6,395 total)