Viewing 15 posts - 121 through 135 (of 534 total)
When I installed the instances.. all system database files (master, msdb, model and mssqlsystemresource) were in folders with the following (default) naming convention:
E:\Microsoft SQL Server\MSSQL.1\MSSQL\Data
E:\Microsoft SQL Server\MSSQL.2\MSSQL\Data
E:\Microsoft SQL...
April 12, 2011 at 1:12 pm
yes. the path(s) where I moved the the system data files to are named like this:
F:\MSSQL\Servername\Default\Datafiles
F:\MSSQL\Servername\Datafiles
F:\MSSQL\Servername\Datafiles
and
G:\MSSQL\Servername\Logfiles
G:\MSSQL\Servername\Logfiles
G:\MSSQL\Servername\logfiles
They are named with the actual Instance NAME - not the MSSQL.1 MSSQL.2...
April 12, 2011 at 12:51 pm
I have multiple instances. I have mssqlsystemresource database files in the following paths:
E:\Microsoft SQL Server\MSSQL.1\MSSQL\Data
E:\Microsoft SQL Server\MSSQL.2\MSSQL\Data
E:\Microsoft SQL Server\MSSQL.3\MSSQL\Data
I know the MSSQL.1 is my default Instance...
I just...
April 12, 2011 at 11:41 am
I get this
Msg 911, Level 16, State 1, Line 1
Could not locate entry in sysdatabases for database 'mssqlsystemresource'. No entry found with that name. Make sure that the name is...
April 12, 2011 at 10:53 am
Is there a query (or queries) that can be run that will tell me where the master and mssqlresource database files are located for a partucluar instance?
April 12, 2011 at 10:35 am
Thank you. I will put things back the way they were .. except for TEMPDB of course : )
April 12, 2011 at 10:29 am
Mine is Honey. At the time of this pic, she was about 7 months old. Beautiful American Bulldog : )
We lost Honey during the whelping of her TWELVE...
March 3, 2011 at 8:25 am
Sometimes it's just nice to have someone to bounce things off of : )
February 25, 2011 at 8:34 am
Try Control Panel under Regional and Language Options (I'm looking at this in XP, so your server OS may have a slightly different name for this). From the the Regional...
February 25, 2011 at 6:49 am
What OS collation are you using?
I do not know how to determine the OS collation. :blush:
How is the data being inserted? Via a client front end, SSIS, Bulk Insert, etc.?...
February 25, 2011 at 6:25 am
Just a regular table.
February 25, 2011 at 5:21 am
I did some poking around and created a temp table using the DDL from the original table.
I inserted Najwyzszy Rycerz Przewodniczyl Dyskusji Panelowej Organizacji Narodów Zjednoczonych
into a column of...
February 24, 2011 at 12:43 pm
Viewing 15 posts - 121 through 135 (of 534 total)