Wednesday, May 29, 2013

[SQL 2012] Need Quick Help Please about SQL Server 2012

[SQL 2012] Need Quick Help Please about SQL Server 2012

Need Quick Help Please about SQL Server 2012

Posted: 29 May 2013 02:59 AM PDT

I never used SQL Server 2012. I need to install on one of our server and the system admin installed the ISO file and he provided the infor asSQL Server 2012 enterprise edition SP1- per core SQL Server 2012 enterprise edition SP1- server/CALIs it SP1 for SQL Server 2012 or the whole SQL 2012 with SP1? Please help!!!

xp_create_subdir cannot find the path specified

Posted: 28 May 2013 04:16 AM PDT

I'm struggling to deploy MyDevDatabase to my local development environment on my workstation.The script to create MyDevDatabase assumes SQL Server can write to a G drive. This works well enough in production because all of our production servers have a partition for the G drive.I faked a G drive by the following steps:* create the directory D:\MyDevDatabase* Share the directory as \\localhost\MyDevDatabase* Map the network location \\localhost\MyDevDatabase to drive G.* Grant full control to the G drive to the SQL Server database engine following [url=http://msdn.microsoft.com/en-us/library/jj219062.aspx]the MSDN instructions[/url].The first step of the script creates the directory structure for database files on the G drive. A typical statement looks like this:[code="sql"]EXECUTE master.sys.xp_create_subdir N'G:\MSSQL\SQLData\MyDevDatabase';[/code]On my workstation this fails with an error message like this:[quote]Msg 22048, Level 16, State 1, Line 0xp_create_subdir() returned error 3, 'The system cannot find the path specified.'[/quote]If I change the command by replacing the mapped drive with the shared directory like this:[code="sql"]EXECUTE master.sys.xp_create_subdir N'D:\MyDevDatabase\MSSQL\SQLData\MyDevDatabase';[/code]Then the command completes successfully, and the directory structure is created.I'd like to make this work without modifying the deployment scripts.Is there a better way to fake a G drive for SQL Server?Do I actually have to create a partition?

Linked Servers and windows Authentication

Posted: 28 May 2013 08:48 PM PDT

Right ive been on holiday and my first day back so maybe i am having a dumb;-) day or it just cant be done. Thought i'd ask the people of SSC for help :-D.I am trying to create a Linked Server between servers on the same domain, which seems simple enough and i have done so already using a SQL login which allows me database access. The issue i am having is that i need to change this login to a static Domain User Login.What i mean is that no matter what users uses the linked server it logs into the remote server under the same domain user. The reason for this is that the recipient servers database(s) CRM has inbuilt security which requires a windows user to access information via its filtered views and i am trying to take advantage of these views. If i use a SQL login i cannot access data via the filtered views because it has no AD information available in the CRM DB Users tables which means i need to access the underlying tables which can be done but leaves me open to issues when development or upgrades occur. I cannot replicate the database because this causes issues on the source CRM server.Any help would be appreciated..

Cumulative Update to client servers

Posted: 28 May 2013 11:53 PM PDT

Hi Gurus,I recently applied CU3 update to our database server with SQL Server 2012 SP1 (version 11.00.3000), I have a question regarding to our remote servers with client only installation, it appear it did not upgrade to version to CU3 (11.0.3349), so do I need to apply CU3 update to each of the servers with client installation?Thanks

SQL Server 2012 Licensing on Individual VM's

Posted: 28 May 2013 11:15 PM PDT

If I'm licensing Individual VM with 8 cores, And I install 2 named intances do I need an 16 Licenses?

NUMA and PLE on SQL Server 2012

Posted: 04 Feb 2013 11:26 PM PST

I've read both Paul and Jonathan's blogs regarding this issue (http://www.sqlskills.com/blogs/paul/page-life-expectancy-isnt-what-you-think/) and started looking at the PLE counters for each individual NUMA node. I can't seem to wrap my head around why there is such a widespread discrepancy between the NUMA nodes. We are running SQL Server 2012 Enterprise Core. Any insight would be greatly appreciated.Thanks,Tommy[url=https://skydrive.live.com/redir?resid=EB98D18648791013!7197&authkey=!AN6DKRDzgyJlarU]https://skydrive.live.com/redir?resid=EB98D18648791013!7197&authkey=!AN6DKRDzgyJlarU[/url][img]https://skydrive.live.com/redir?resid=EB98D18648791013!7197&authkey=!AN6DKRDzgyJlarU[/img]
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog