Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







How To Move Server Root Directory To Another Partition?


I want to move the SQL Server 7.0 root directory from C:MSSQL7 to D:MSSQL7 (same host). I see the startup parameters under server properties could be changed to point to the new location, but Master has the paths to all the databases recorded in sysdatabases table, so at least that would have to change, and sysdevices table points to files on C:. And maybe the NT registry points to some files there too. Anyway, is there some established method to move it? If that isn't practical, at least I would want to move TEMPDB ( perhaps by using the SP_DETACH and SP_ATTACH method ). My main database is already on D: so I do not have to move it. Any informed advice would be appreciated. Thanks.


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
How To Change The Root Directory?
Hello,



I was wondering if it were possible to change the Root Directory on an SQL Server 2005 install?



expl: current = C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQL



desired: D:Program FilesMicrosoft SQL ServerMSSQL.1MSSQL

View Replies !   View Related
Root Directory Of SSIS Package
Hi everyone!
I have a configuration file, I want to place it in somewhere of SSIS package to extract configuration information. But i dont know where is root directory. can you help me?
Thanks you very much

View Replies !   View Related
How To Change Default Database 'root Directory' ?
Hi folks,

Can you please tell me how should I change the default root directory (used for db storage) in SQL 2005 Std. Edition. ?

Currently its configured to:
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQL
and I want to change the drive letter here.

Thanks in advance.
Cyk

View Replies !   View Related
Does SQL Server Move Records Between Partitions When Updating The Partition Key Column?
If I run an UPDATE query on a table which is partitioned by the column I am updating - will the records be moved to another partition?



ie. I have a table where Historical bit column marks whether a particular record should go to Partition1 (=0)or Partition2 (=1). Now, I update a record in that table and change the Historical column value from 0 to 1. What happens with that record?

View Replies !   View Related
Move Sql Database From Development Machine To Server With Active Directory
Hi all! I know I might sound stupid, but I have this problem. I have developed my database on my laptop which does not use Active directory. Lets say I access the database with: SPIDERMANDB1 on SQL server, where the name of my laptop is SPIDERMAN, and the database is DB1. Now, I create an SQL script from sql server and make the necessary changes, like changing the computer name to say, SUPERMAN where my deployment server's name is SUPERMAN. But when I run the SQL script on the SUPERMAN server, it gives me an error like: "User or role SUPERMANDB1 does not exist in this database". I have deployed databases in this way on servers without Acive directory, so I'm sure its not a mistake on my side. So how am I supposed to go around this active directory thingi! Please help me out! I'm counting on u guys!

Wes

View Replies !   View Related
I Want To Get The Root Appliation Path For Loading A File Which Is In My Root Folder Of Windows Application


hi
my application is applocation1 i kept a file in this folder i want to read it from application how can i get the path of that file in my application.

i want to read the file in my root folder excluding the bin path

Please any one know the answer let me know ..

thanks and regards
Ravishanker Maduri

View Replies !   View Related
Move Staging Data To Weekly Partition
I have a process that loads about 500,000 records on a daily basis and normally takes somewhere in the neighborhood of 5-10 minutes to complete. First I use a SSIS Package to load the data into a staging table, and then call a Stored Procedure that determines which weekly table the data belongs in, and executes dynamic SQL to move the data from the stage table to the final table. It's working pretty well except that the Monday load (Sunday's data) is taking around 10 hours to run, instead of the normal 10 minutes. The only difference I see is that when it is copying data from the stage table, Monday's load will be adding the first rows to the week's partition. I have one clustered index on the table, and data from the staging table should be in the same order. There is also a Non-Clustered index on the ID field that is added as part of the insert. Does anyone have any suggestions for things that I can look at? It makes no sense to me, why an empty table would be 60 times slower...

View Replies !   View Related
File System Task - How To Move Directory Contents


Hi,

I want to move all files of one directory/folder into another usng SSIS, like in DOS Prompt we use the command,

Move d:ftpSource*.* d:ETLSource

I have tried by creating a file system task, but there is no option for Move Directory Contents. Move File is not accepting wild cards.

Regards,

Imran.







View Replies !   View Related
How To Move The Bad Data Into Another Directory While Looping Through A Set Of FLAT FILES ?
Currently looping through the set of flat files like CHK0604, CHK0611, CHK0618, and CHK0625 from the source folder C:SOURCE



OBJECTIVE within the flat file if any records/rows cause error i have to move the bad data into separate folder C:ERROR



STEPS TAKEN

1) In FOREACH LOOP component i specified the variable User:: sourceFilePath for my source file CHK0604 etc. location C:SOURCE. The loop walkthrough each file in C:SOURCE and if no error then moves the flat file into another folder C:ARCHIVED. This task is perfectly working.



2) Within the dataflow I am diverting the the bad rows from "conditional component" into "Flat File Destination" Component.



3) "Flat File Destination" Connection manager i set the expressions as @[User:: sourceFilePath] +"_Error.TXT".



ISSUE

Because of point (3) the error file is created in the SOURCE flat file location C:SOURCE.



QUESTION



1) My error file name should be CHK0604_Error, CHK0611_Error, CHK0618_Error, CHK0625_Error created in another folder C:ERROR.



2) How to move the bad data into another directory while looping through a set of FLAT FILES ?

3) If i have to create another variable like @[User:: ErrorFilePath] where to create ? How to use the source file title as the title of error file.?

Thanks for the help


View Replies !   View Related
Move Files From Directory Based On Names On A Static List.
I have a scenario where I need to move a series of files from within a directory of many files. The files follow no nameing convention and are more of less random. However the file names never change from week to week. I tried various different options in a 'file system task', no go.
Any ideas on how to move only a list of files?

or

can I load only specific files into a 'Foreach Loop container' from a certain directory. I tried delimiting file names in the file source, that did not work.

Either way can work,
Thanks

View Replies !   View Related
Using Provider For Microsoft Directory Services For Querying Active Directory
Has anyone used this successfully from an OLEDB source component, or even from the Execute SQL Task? I've seen some examples of using a script component, but nothing that uses it through a connection manager.

View Replies !   View Related
Partition SQL Server
Hi,

I am using SQL Server 2000 SP3 Version 8.00.7.60. Can I create instances of SQL server 2000 even if it's already installed?

Thanks for your help in advance!

View Replies !   View Related
How Does SQL Server Know Which Partition To Look At?
Most examples for SQL Server 2005 involve a sales table that you split based on date, i.e. sales records prior to 2000 go to this partition, and the ones after that go to another one. Nice and simple.

Say I have a sales table:

id Amount Date
1 10 1/1/1999
29.99 1/1/2007

Now then, I put all the records prior to 2000 in it's own partition.

So when I do something like this: SELECT * FROM Sales WHERE DATE = 1/1/1999
the SQL server will know which partition to look at. Very nice.

Now then, if I do this: SELECT * FROM Sales WHERE id = 1
How will the SQL server know which partition to look at?


Thank You!

View Replies !   View Related
To Have No FAT Partition - Good Or Bad For Server?
Hi!
I'm installing a new SQL Server machine. During NT Server
installation our NT support guy converted the only 2GB FAT
C: partition to NTFS. So as of right now all my 4 8GB drives are
NTFS. I think it would be better to keep this C: partition in FAT
because, as of my knowledge, having FAT boot partition can help
to boot the machine in case of NT crash.

Is there anything that I'm really losing by this conversion to NTFS or I
should not be worried so much about it? Does it put my SQL Server
databases, database .dat files or NT Server in more danger situation
in case of any crash?
Or it's giving me some advantages?
Thanks
Ninel

View Replies !   View Related
ABOUT Sql Server 2005 Partition
hello,

We are writting an erp for group,and want to use partition of sql server 2005 for large data,our environment is window 2003 server,8g memory.my one solution will create many physical files(about 500-600) to fit 500-600 partitions,how about performance? or I will use another arithmetic in order to reduce partitions?

View Replies !   View Related
Table Partition In SQL Server 2000
I have createdtheT1tablewhichwillacceptUSrecordsandT2tableforanyothercountry.


CREATETABLET1(IINTunique,namevarchar(10)CHECK(name='US')PRIMARYKEY(I,name))

CREATETABLET2(IINTunique,namevarchar(10),CHECK(nameNOTIN('US'))PRIMARYKEY(I,name))

Then Created the partitioned View using below script
CREATEVIEWVAS
SELECT*FROMT1
UNIONALL
SELECT*FROMT2

IamabletoinserttheUSrecordsusingview
insertintoVvalues(1,'us')

Problem:
IamnotabletoinsertthenonUSrecordslikeUKandJN...
Itisthorwingtheexceptionlikepartitioncolumnnotfind.
eg:insertintoVvalues(1,'uk')


PLeasehelpmetoinsertthenonUSrecordsintotheView

View Replies !   View Related
FOR XML Sub Root
Hi all
I am trying to create xml file from the data, everything works fine cept I can't get the format that I need.

This is my SP:

WITH XMLNAMESPACES (
'urn:http://base.google.com/cns/1.0' as "c"
, 'urn:http://base.google.com/ns/1.0' as "g"
)

SELECT top 2
TITLE "item/title",
description "item/description",
employer "item/g:employer",
job_type "item/g:job_type",
link "item/link",
location "item/g:location",
salary "item/g:salary",
education "item/g:education"


FROM JobExport
FOR XML PATH ('chanel'), ROOT('rss')

I need to get:

<rss version="2.0" xmlns:g="http://base.google.com/ns/1.0" xmlns:c="http://base.google.com/cns/1.0">
- <channel>
- <item>
<title></title>
<description></description>
<g:employer></g:employer>
<g:job_type />
<link></link>
<g:location></g:location>
<g:salary />
<g:education></g:education>
</item>
- <item>
<title></title>
<description></description>
<g:employer></g:employer>
<g:job_type />
<link></link>
<g:location></g:location>
<g:salary />
<g:education>High School</g:education>
</item>
</channel>
</rss>

but I get this:


<rss xmlns:g="urn:http://base.google.com/ns/1.0" xmlns:c="urn:http://base.google.com/cns/1.0">
<chanel>
<item></title>
<description></description>
<g:employer></g:employer>
<g:job_type></g:job_type>
<link></link>
<g:location></g:location>
<g:salary></g:salary>
<g:education></g:education>
</item>
</chanel>
<chanel>
<item>
<title></title>
<description></description>
<g:employer></g:employer>
<g:job_type></g:job_type>
<link></link>
<g:location></g:location>
<g:salary></g:salary>
</item>
</chanel>
</rss>

The problem is that the "chanel" need to be a subroot (not sure what else to call it)

View Replies !   View Related
Partition Merge Performance - Sql Server 2005
Does anyone know of any documentation on the performance of partitionmerge/split? Does the merge or split of a partition cause any lockingon the partitioned table? If you were merging or splitting a largevolume of data rebalancing your partitioned table would youpotentially lock users out?

View Replies !   View Related
I Need To Be Able To Install SQL Server 2005 On A Different Partition Besides The C Drive. Thanks

I created two partitions for my hard drive. The C drive which holds all of the Windows 2003 server operating system files and E drive which will be just for data and applications. The C drive is only 30GB while the E drive is 119GB. I need to be able to install in the application on the E drive. I already tried creating a folder on the E partition named program files with the sql2005 folder in it when I go through the installer package. SQL server still wants to be installed on the C drive. Is there anyway I can change this so it gets installed on the E partition. Thank You



View Replies !   View Related
I Need To Be Able To Install SQL Server 2005 On A Different Partition Besides The C Drive
I created two partitions for my hard drive. The C drive which holds all of the Windows 2003 server operating system files and E drive which will be just for data and applications. The C drive is only 30GB while the E drive is 119GB. I need to be able to install in the application on the E drive. I already tried creating a folder on the E partition named program files with the sql2005 folder in it when I go through the installer package. SQL server still wants to be installed on the C drive. Is there anyway I can change this so it gets installed on the E partition. Thank You

View Replies !   View Related
Truncate A Partition Of Partitioned Table In SQL Server
Hi All,

I am new to SQL Server. I have a table which is paritioned by Value (String). Can I write a stored procedure or an SQL Statment to truncate a particular partition in SQL Server. Please suggest me on this.

Thanks
Chow

View Replies !   View Related
Root Node From A FOR XML
Hello,

How can I get a XML with a root node from a FOR XML ?:
Now I have this:

The SQL:
SELECT * FROM Table_Projects Project
FOR XML AUTO

and the XML output:
<Project>
    <ItemID>1</ItemID>
    .....
</Project>
<Project>

    <ItemID>2</ItemID>

    .....

</Project>
...

and I want this:


<Projects>
    <Project>
        <ItemID>1</ItemID>
        .....
    </Project>
    <Project>
        <ItemID>2</ItemID>
        .....
    </Project>
    ...
</Projects>

thanks and regards,
Edu

View Replies !   View Related
Installation Of SQL Server 2005 On The Partition Disk Drive
Trying to install SQL Server 2005 beta version on partition disk drive sayF: (Other than local disk drive c:),Does anyone know how can I do this? During the installation, it never asksme on which drive it install to nor browse button is there to browse thedisk drive for installation...Any help???ThanksJ.

View Replies !   View Related
Different Login && SQL Console Root .....
Logged on local Administrator on one of my sqlserver 2000 "ABC" and registered 5 sql groups and linked 50 sql2k servers from MSDE to Standare (all sp3).
Now, I need a different login on this machine "ABC", how could I get back all the SQL Enterprise Manager Console Root Setting and connections like before?

thanks
David

View Replies !   View Related
XML Source - What About The Root Element?
Greetings!

Why does XML Source in MS VS 2005 Integration Services Data Flow Sources XML Source not pick up the root element?

The problem is the following example:
<root createddate="2008-01-01">
<elements>
...
</elements
</root>

The XML Source picks up everything after the first element which is the root element but it does not seam to pick up the root element where there is a need for the createddate attribute.

Is there a soultion for this problem or a workaround?

Thanks for help.

View Replies !   View Related
Retrieve Value Of The Root Attribute In XML
Hello everyone,

I have an xml file that looks like this:

?xml version="1.0" encoding="UTF-8"?>

<WHOLE Date="*********">
<MAIN .......</MAIN>
</WHOLE>

What i need is to find a way to retrieve the value of the attribute belonging to the root element (value of @Date) in SSIS.
Tried it using Xpath but don't know how i should configure the xml task editor or if maybe there's any other way to perform such a task.

thank you

View Replies !   View Related
Master Database On Root Drive??
I have a 'need an opinion' question. I've always installed the system databases (master, msdb, model, tempdb) on the root drive (c:) with the sql application. Then I was thinking, the only things that really should be on the root drive is the sql app itself (and any other required apps). So...my question is, do y'all install the master, etc on a separate drive other than the root, ie d: or e:? The reason I ask is that if the tempdb database has alot of activity, and the database resides on the root drive, could it affect sql performance?

Just wondering. I just started working in a 'virgin' sql environment (setting up sql servers from scratch), and want to have sql installed in the best possible way for performance.

Thanks in advance for any info y'all can provide.

View Replies !   View Related
Does Anyone Know How To Change The Document Map Root Text?
hi, guys
Does anyone know how to change the Document Map root text? For example, i have report, the file name is sc.rdl, and then the root is sc. Apparently this is not good. I am thinking is there a way to change it.

View Replies !   View Related
Root Element Is Missing Problem
Configuration: SQL Server 2005 Enterprise edition on Microsoft Cluster. Machines named Node1, Node2 and NodeV (Virtual Node). Best practices require SSRS be deployeed on an IIS6.0 server. Reporting services was installed on the Web1 machine and pointing back to the database on the NodeV platform. Everything appears to run fine in Reporting Services. However, when I use the ReportViewer control from within a webpage, the basic control appears along with the message "root element is missing". Using the same code, I point the ReportViewer control to a different server Web2 where Sql server standard, IIS and RS are installed and the report renders properly. What am I missing in the configuration of the Web1 box as far as IIS or SSRS are concerned?



View Replies !   View Related
How Can I Directly Include A Square Root In A SQL Query
I have an ASP.NET application where I need to filter the records returned from a SQL query using a calculated distance to a point that is set by the user.   To do this directly, I would need to include a square root of an expression in the SQL query.  It seems like I should be able to do this by writing my SQL query something like:
SELECT SQRT(expression ....) AS distance, column2, column3 ... FROM mytable WHERE distance < 50
Unfortunately, SQL queries apparently don't like the SQRT function.  I am using .NET 2.0 with VS2005 and a MS Access backend (that will soon be moved to SQL/Server).
As an alternate, maybe I can query the data into a temporary record set with a extra field for distance and then step my way through the temporary record set and replace the values in the distance field with a calculated distance.  Once the temporary record set is prepared, then I would delete the records that don't pass the distance requirement or otherwise hide them and bind the data to a gridview control.
Thanks,
David

View Replies !   View Related
Putting Attribute On Root Node Using FOR XML PATH
I would like to know how to put an attribute on the root node of thexml returned from a FOR XML PATH query. One thing I tried is this:selectm.msgid '@msgID',st.namelong 'set/@namelong',st.nameshort 'set/@nameshort',frommsgset minner join settable st on (st.setid = m.setid)where m.msgID = 195for xml path('set'), root('message')but it gives me:<message><set msgID="195"><set namelong="STUFF HERE" nameshort="STUFF" /></set><set msgID="195"><set namelong="MORE STUFF" nameshort="M STUFF" /></set><set msgID="195"><set namelong="TESTING 123" nameshort="TEST" /></set></message>here is what I want:<message msgID="195"><set namelong="STUFF HERE" nameshort="STUFF" /><set namelong="MORE STUFF" nameshort="M STUFF" /><set namelong="TESTING 123" nameshort="TEST" /></message>I can't get it. If I use: root(''), then it tells me: "Row tagomission (empty row tag name) cannot be used with attribute-centric FORXML serialization." I'm sure there is a trick to this-- anysuggestions?Many thanks.the chippster

View Replies !   View Related
INTERNAL ERROR Com_check Root->right Before Compile
Could someone tell me what "[INTERNAL ERROR] com_check root->right before compile" means, I get it in the SQL error log. It comes right after "Unable to recognize network login packets" (also get lot if these on another server). I think I know what the "Unable to recognize login packets" error means, but I am unable to get any information on the INTERNAL Error problem. HELP! Oh by the way, we are running MSSQL Server 6.5 on NT 4.0, it has been upgraded with service pack 5. Also, the front end application is called MP2 for the maintenance department to track tasks. All of the users are either logged in through PC to server or intranet to server.

View Replies !   View Related
Using Application.ExistsOnDtsServer, Root Folder Unknown
Hi... I'm using an object of type Microsoft.SqlServer.Dts.Runtime.Application and I want to use the ExistsOnDtsServer method

http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.application.existsondtsserver.aspx

I am loading an MSDB-related SSIS package located in the root SSIS folder.
Originially, the root MSDB folder was named "MSDB", so this call would work...

Dim app As New Microsoft.SqlServer.Dts.Runtime.Application

blnReturn = app.ExistsOnDtsServer("MSDB" & Me.PackageFolderPath & "" & Me.PackageName_SSMS, Me.Datasource)

but now, the "MSDB" folder has been renamed to "MSDB - <ServerName>", which the same code above now bombs.

I could change the code above to insert the servername, but I'd like to find something more automated to work for a root folder of any pattern.

Is anyone aware of a way to pull the root folder name through T-SQL, or some sort of wildcard character that bypasses specifics?

blnReturn = app.ExistsOnDtsServer("*" & Me.PackageFolderPath & "" & Me.PackageName_SSMS, Me.Datasource)

View Replies !   View Related
Remove ROOT Tags From SQL Task XML Results
Hi All,

I'm currently using an Execute SQL Task to return XML data from a query into an SSIS string variable. In my FOR XML clause in SQL I'm specifying a certain name for my root tag, called "Accounts". This works great in Management Studio, however, the Execute SQL Task appends a <ROOT> and </ROOT> tag to the start and end of the string, so now it looks like:

<ROOT><Accounts>...all my elements...</Accounts></ROOT>

I'd like to remove the ROOT tags so that the <Accounts> tags are actually the root for this doc. What would be the best way to remove the ROOT tags from the SSIS string variable?

Thanks!

View Replies !   View Related
Need Help In Pulling Out A Date In The Root Portion Of An XML File
Below is a file that I have loaded into a Sql table:

<btb-root xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" btb-num-trans="2" btb-date="2006-11-09" btb-time="22:40:03" btb-sender="BTB" btb-receipient="BPO-USR">

- <btb-request req-method="Asynchronous">

- <req-header>


<req-btb-id>68790</req-btb-id>

<req-client-id>1133</req-client-id>

<req-product>BPO-Exterior</req-product>

<req-loan-number>00000</req-loan-number>
</req-header>

- <req-property-address>


<addr1>1115 TEST DR</addr1>

<city>TEST</city>

<state>TEstate>

<zip>30044</zip>
</req-property-address>

- <req-borrowers borr-type="Borrower">


<first-name>Test</first-name>

<last-name>TE</last-name>
</req-borrowers>
</btb-request>

My goal is to take the btb-date and store it in the same table I loaded the seperate nodes to. Currently I am loading the req-header, req-property-address, and req-borrowers.

This date will be static in that it will remain the same for every record. My goal is to read it in and store it along with each record. Hope someone can give me some help.

Thanks.

View Replies !   View Related
Can't Create File At The Root Level Of Mount Point
Dear all,

I was trying to create filegroup and files on Mount Point, e.g. C:MOUNTFG1D1
If I try this:
.......
FILENAME = 'C:MOUNTFG1D1FG1F1.ndf',

It doesn't work, no matter what ACL I set on C:, C:MOUNT, or C:MOUNTFG1D1

But if I do this:

......
FILENAME = 'C:MOUNTFG1D1DATAFG1F1.ndf',

It will work, no need to set any ACL at all.

Any ideas?

dong

View Replies !   View Related
Navigation From The Root Folder To Specific Folders For Users
Hi there, I have the following setup in the report manager:

Root
|_ Sales
|_ Sales Export
|_ Marketing
|_ Production
|_ etc...

Now, I know that I can access each folder (f.e. Sales) by directly putting it into the URL. Is there a possibility to enable every user to the root folder and then denying access on specific folders? F.e.: Our Head of Sales should be able to navigate to the root folder and then dcecide whether he wants to enter the Sales or the Sales Export folder.

Is this possible? I tried a few things, but nothing works.

Thanks in advance!

View Replies !   View Related
Converting Relational Data Into XML With ROOT NODE NAME In SQL 2000.
hi All,
I tried following piece of code in SQL 2005 , is working fine.
Select * from Table
FOR XML RAW('RECORDS')ELEMENTS,ROOT('MyTable').
But when i tried the same thing in SQL 2000 , it was not working .
Plz suggest a way in 2000 to get the XML output with custom RootNode Name in 2000 also like in 2005 ?
Thanks in advance.
Mohit

View Replies !   View Related
Root Element MIssing &&amp; For Security Reasons DTD Is Prohibited In This XML Document
This error comes up in the print preview and nothing prints.

We are using VS-2005, SQL 2005 and SSRS 2005.

We had the same problem yesterday , so we have reinstalled IIS, .Net Framework 2.0 and Reporting Services, then reconfigured RS security, uploaded all the reports and enabled remote errors. After doing everything this error was gone and we were operating pretty fine.

Suddenly just we started getting the same annoying message."ROOT ELEMENT MISSING" from Report Server and from Report Manager we have "
For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method. "




Please Help. I need to fix this ASAP.


View Replies !   View Related
SQL Server And Active Directory
Hello,

I have recently upgraded my the server that runs SQL Server to an Active Directory Domain Controler. Now I can't connect to the SQL Server from ASP.NET Applications when the application is not located on the local machine. The error message I get is SQL Server does not exist or access is denied.
I have no problems connecting with QueryAnalyer and Enterprise Manager from my workstation. I have added the Sql Server to the directory via the "Active Directory"-tab in the Property window for my Sql Server Registration i Enterprise Manager.
If I copy a directory from the wwwroot on my workstation to the server the application has no problem to connect so the connectionstring seams to work fine.

Any ideas?

Regards,
Kalle

View Replies !   View Related
BCP By Mapping A Directory On The DB SERVER
I have a question regarding BCP. We are doing a BCP operation from one machine to another machine. (i.e) Flat file from the web server are BCP on to the DB server. For this operation we have mounted the FTP directory of the web server on to the DB server. Say G: drive of the DB server is mapped to the Ftp directory of the web server.

Now when we run the BCP we get the following error.

SQLState = 08001, NativeError = 6
Error = [Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL server not found.
SQLState = 01000, NativeError = 53
Warning = [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen (Create File()).

The connection is using NAMED PIPES.

Say when we BCP out the above error message comes but the flat file is generated with out any records in it.

Are we missing any parameter settings.

Please help.

View Replies !   View Related
Robocopy SQL Server Directory
I am in the process of creating a VM server which serves as a backup for a production SQL server. the SQL server has SQL directory installed on C: and F: partitions. Sql installation files reside on C: while MSSQL directory (include backup, logs, data, etc.. ) reside on F:. The VM was created by cloning of the original (production) server but only C: partition. I need to use robocopy to copy the MSSQL directory from original sql (F:) server to the VM (F:). My questions are:

1. will doing it this way mess up database integrity on the VM?
2. What should I check to ensure installed filed registered to the new VM server instead of the original sql server?
3. what switches of robocopy should be used to produce exact copy of the MSSQL folder from original server to the VM
4. the current database is about 1GB, how long the robocopy may take?

If you have experienced this before, please share your thoughts, suggestions, ideas. Very much appreciate your feedback.

Thank you

View Replies !   View Related
IIS Virtual Directory Management For SQL Server ???
Hi --
 I'm trying to move our web sites from IIS 5 to IIS 6.  We are using SQL Server 2005 as a backend database so I had that put on the new IIS server instead of SQL Server 2000 tools.  Anyway, now I'm at a loss.  I can't find the IIS Virtual Directory Management for SQL Server.  How do I set up my XML for my treeviews?  Or do I need to remove SQL Server 2005 and go back to SQL Server 2000?  There must be a replacement in 2005 that I should be using.
 thanks,
 jekerry

View Replies !   View Related
SQL Server Active Directory Query
Hi,

I need a SQL procedure to query the active directory and list the members details of a particular group. I am new to LDAP and any help would be
appreciated.

I've tested few scripts like the one below on Query Analyser to see how the whole thing works and it did work but it's not all the users that I need. I want to filter the search to members of a specific group.


SELECT sAMAccountName as [User Name]
FROM OpenQuery(ADSI,'SELECT displayName, sAMAccountName
FROM ''LDAP://192.168.0.1'' where objectClass = ''User''')

Thanks

View Replies !   View Related
Get Data From Active Directory To MS SQL Server
I look for and try to get data from Active Directory to MSSQL Server, but have same error:

Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing the query "SELECT name
FROM 'LDAP://office.experter.group'
WHERE objectCategory = 'Person' AND objectClass = 'user'" for execution against OLE DB provider "ADsDSOObject" for linked server "ADSI".

for the code:

select * from openquery
(
ADSI,'SELECT name
FROM ''LDAP://office.experter.group''
WHERE objectCategory = ''Person'' AND objectClass = ''user'''
)

I create linked server:

EXEC master.dbo.sp_addlinkedserver @server = N'ADSI',
@srvproduct=N'Active Directory Services', @provider=N'ADsDSOObject',
@datasrc=N'office.experter.group'

I've changed security setting, format of LDAP. Please advise me

View Replies !   View Related

Copyright 2005-08 www.BigResource.com, All rights reserved