I have a question on how to change a hyperlink path. I have an ADP that has our scanned files linked to it the path is on SQL server. The problems is that we are migrating sql server and the files to their own seperate server,
\gcfs01databaseBackgroundsSCANNED ACROBAT DOCUMENTS (BACKGROUNDS)SCANNED ACTIVE FILES5630.pdf
The server is called \gcfsql Instead of gcfs01.
does anyone know how we can change the unc path to gcfsql without
\gcfsQLdatabaseBackgroundsSCANNED ACROBAT DOCUMENTS (BACKGROUNDS)SCANNED ACTIVE FILES5630.pdf
Hi: I'm using SQL SERVER 2005 EXPRESS My server name is SERVER1SQLEXPRESS When I create a new data base on my server it saves at C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData How Can I change this default path? Thanks!!
I instance where customers want to migrate SQl dB to a new server. I want to change part of the path to lowercase.
The part to be change is always a computer name i.e. ComputernameDatareportA24440 testUser.doc I want to define the computername and the script changes only the computername to lowercase
Using Update Table set Path =LOWER(Path) -- etc. Go
Changes all the path to lowercase,
Note the Computername will always be different depending on the customer. The reason for changing the PCname to lowercase each client can type the PC name in various ways
Hi, In my system, for creating a databae the default path is in C: drive, but iwant to change into D: drive as a default path.Please tell me how to change??
I need someone that knows something about SQL queries.
I have a client that is running a Database known as ProLaw. It is in part a document management system for Law Offices.
They have an SQL 2005 database that tracks per client all the documents they create.
We had to replace there server with new server. The new server is running sbs2003 and had to have a different Netbios name then the old sbs2000 server. (Small Bus. Server has some weird quirks that make simply using the same netbios name impossible. Google search it if you don't believe me.)
The database holds in a single column the full network share path to each document.
Different documents may have different names and more subdirectories but the root path of "\lawwillsbs2000ProlawDocuments" is shared by all.
The new server is named \sbs2003 I need to change the first part of almost 3000 path statements to the new server. The rest of the path is unchanged.
I have had several people running prolaw tell me that I should run this query:
UPDATE Events
SET DocDir=REPLACE(DocDir, '\\lawwillsbs2000', '\\sbs2003')
WHERE EventKind='O'
This doesn't work. Nothing is changed. I'm guessing it is because this query assumes the value will be ONLY \lawwillsbs2000 I see nothing in here that tells the query that this is only part of the string. No wild card or other marker.
I need some kind of string function here do I not? Anyone know enough to help me craft a proper query?
Currently we have SQL instance on C: drive.We are now going to upgrade SQL Server 2008 RTM to SQL 2008 SP4.Can we change the path of SQL instance during upgrade?What services need to be stopped during upgrade.
acutally my network dept. has change the backup file server IP address.. i m now hving problem for taking backup. i have around 85 backup that runs everyday.. what i m doing now running every single command to drop backup device and then adding again.. but it's taking agess to do..
is there any simple script that just update the device path folder..
I want to redirect the logshipping primary backup folder to another drive, how to change the configurations steps to move the primary logship folder to another location within the same server!
I have connected to the SQL Server 2005 instance usign the SQL Server Management Studio; I have changed the default locations for the database and log files. I have also rebooted the machine. When I look in the SQL Server Configuration Manager in the properties for the SQL Server (MSSQLSERVER) I see that the data path is still set to the old value and this field is read-only. How can this can changed without going through the registry?
When trying to install Business Contact Manager (BCM) for Outlook 2007, the setup failed and I was refered to a log file in my Local Settings/Temp folder. The log actually says that Business Contact Manager was installed sucessfully! BCM is supposed to install SQL Express 2005 as an instance or as instance if SQL Express is already installed. There is an MSSMLBIZ instance in Services..
Who can I send the Log File to for analysis and the fix feedback?
When I first went into Computer Management and clicked on Services and Applications in the left panel, the error message appeared "Snap-in failed to intialize. Name: SQL Server Configuration Manager CLSID:{CA9F8727-31DF-41D2-975C-887D84903967} This message diappeared when I clicked on Services and Applications again. Under Services, there are 3 SQL services - one is an application that was uninstalled 3-4 weeks ago and I disabled this service. The other 2 are: SQL Server (MSSMLBIZ) and the other one is SQL Server (SQLEXPRESS) When I tried to start either of the last 2, the message appeared: Services "Could not start the SQL Server (MSSMLBIZ) service on Local Computer. Error 3: The system cannot find the path specified. Under Program Files/Microsoft SQL Server/MSSGL.1 folder is mostly empty. So, it seems like the Path in the Registry is not valid and that nothing is being installed in the MSSQL.1 folder. If so, how do I fix this?
How do I get the BCM SQL instance to install and run properly? what do the messages in Services mean and how do I resolve these.
After updating TempDB path to a wrong path (without file name only folder name) the service is not starting. How can i sovle this and start the service
We ran into weird/interesting issue with below details.
Version: Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64) Standard Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200):
We are using SQLCMD to run DDL script on our product database in below order. That script has below content.
step # 1 - database collation change (case -sensitive) statement as very first statement of the script step # 2 - Actual DDL SQL statements step # 3 - database collation change back to original (case insensitive)
When we execute all above 3 steps in single script using SQLCMD on our test_server#1 , it is successful but when same is being implemented on test_ server#2 , it is failing.We ensured that there is no other user accessing the db and setting on both the server are all default/basic. Separating out all 3 steps in 3 different script working fine. This is only problem when we combine them into single script and fire it using SQLCMD. If it is something related to session/transaction then we should hit same issue on our test_server#1 server as well but that is not the case.test_server#1 and test_server#2 has exact same database/data, just two different physical machine & SQL Server instance.
Sorry if this is not the correct forum... I am using the FOR XML PATH feature of SQL Server 2005 (Amazing!!) Is it possible to return multiple rows? For example:SELECT 'Field1' AS 'Element1/@Field1'FROM TableFOR XML PATH('Repeating') Say the above SELECT returns 5 records, I want it to return 5 rows of xml in my ASP.NET application. So in this case each of the 5 rows would contain:<Repeating><Element Field1="Field1"></Element> <Repeating>Instead of returning 1 row with all the xml together.
When using sp_xml_preparedocument @hdoc OUTPUT, @doc I see code everywhere with huge xml text embedded in some store procedures. Can the SELECT XXX FROM XXX FOR XML PATH('') syntax be used instead to produce the second parameter @doc (xmltext) for sp_xml_preparedocument ?
Im trying to reference a ExcelFilePath connection properties using a UNC path, however it doesnt seem to like it, when i use a mapped drive everything works fine.
Hello to all, help, help,... i have with this problem since 3 weeks, until now i cann't resolve this problem. Maybe can somebody help me. I am hopeless. i have a data table ValidRelationship, i will check if there is a relationship between two members by this table. datas in the table ValidRelationship: IDMember IDOtherMember IDType
3700 3726 10000
3726 3700 10000
3742 3672 10000
3672 3742 10000
3422 3548 10000
3548 3422 10000
3548 3717 10000
3717 3548 10000
3675 3695 10000
3695 3675 10000 I will give two member and check their Relationship with a sql query. but it can be that this two member have no relationship. So i define here that man should search processor <= 6 . To better describe i use a example: max. Result of this query is: 1-2-3-4-5-6. If this is a relationship between 1-7 is 1-2-3-4-5-6-7, but i will give a answer that this is no relationship between 1-7. because processor > 6. But my problem is: this query executing is too slow. if i habe two member no relationship, the time of this complete sql query to execute is more than 1 minutes. Is my algorithm wrong, or where is the problem, why this executing is so slow? How can i quickly get the relationships between two member, if my algorithms is not right? The following Query is only to processor = 3, but it works too slowly, so i don't write remaining processors. declare @IDM int; declare @IDO int; set @IDM = 3418; set @IDO = 4270 select top 1 IDMember from v_ValidRelationships where IDMember = @IDM and @IDO in (select a.IDOtherMember from v_ValidRelationships as a where a.IDMember = @IDM)
select top 1 a.IDMember, b.IDMember from v_ValidRelationships as a, v_ValidRelationships as b where a.IDMember = @IDM and b.IDMember in (select c.IDOtherMember from v_ValidRelationships as c where c.IDMember = @IDM) and @IDO in (select d.IDOtherMember from v_ValidRelationships as d where d.IDMember = b.IDMember )
select top 1 a.IDMember, b.IDMember, e.IDMember from v_ValidRelationships as a, v_ValidRelationships as b, v_ValidRelationships as e where a.IDMember = @IDM and b.IDMember in (select c.IDOtherMember from v_ValidRelationships as c where c.IDMember = @IDM) and e.IDMember in (select f.IDOtherMember from v_ValidRelationships as f where f.IDMember = b.IDMember) and @IDO in (select d.IDOtherMember from v_ValidRelationships as d where d.IDMembe = e.IDMember)
If someone has a idea, please help me. Thank a million Best Regards Shasha
I have my SqlDataSource with my connection string:<add name="ConnectionString" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:UsersLaurensDesktopstockmanASP****.accdb" providerName="System.Data.OleDb"/> but I wanted to make a relative path from it because when I put it online i get an error. Thanks in advance
Hey everyone, I'm in the midst of setting up hMailServer on my server and at one point it tells me to enter the name of my database I setup for my email. I entered my database name along with the username and password to access the database. What I'm lost on is the database server address. I thought that would be localhost but I wasn't quite sure and I was hoping that someone might be able to help me with this. Thanks for any help, QWERTYtech
I am having difficulty restoring a database (DB_1) consists of 2 datafiles and one log file, DB Structure is as following:
Filegroup PRIMARY with file name 'fnm_data' with physical file name and location D:dbfile_1.mdf, Filegroup 'FG1' with file name 'fgnm1_data1' with physical file name and location F:dbfile_FG1.mdf, One log file with file name 'fnm_log' with physical file name and location (E:loglog_db.ldf)
{Note} Logfile resides on E drive whereas Datafiles reside on several other drives.
I need to restore the DB on another machine. And I need to move the log file to a drive other than E.In this case it is K drive. Hence I have used the following code,
restore log DB_1 from disk='M:kupccciclog.txt'
WITH RESTRICTED_USER , MOVE 'fnm_log'
TO 'K:DBlog_db.ldf', recovery, replace,RESTART
go
When I try to restore from backup files, I keep error message saying "Physical file name E:loglog_db.ldf may be incorrect." 'fnm_log' cannot be restored. Use Move command to identify a valid location for the file.
Even though I am using Move command to move the log file.
Then I found that if I create a drive with E: and a folder named 'log' then restore program runs alright. That is, when E:log exists then code does run smoothly. All the restore code is looking for the presence of path of the log file from where it is been backed up. In this case it is E:log folder. Once the database is restored I could kill that directory and nothing happens. Also log file has been restored on K:DB only.
Why the restore code is looking for the initial drive letter and path even though I have used Move command? Is there an issue in my code?
How do I dynamically change the file path for the source file in DTS? Can i use global variable?. if so , How do i use it in the connection task. Appreciate your help.
15 or so databases are being backed up overnight to a remote server using UNC paths. All bar one database is being copied fine. The one that isn't is the largest at 8gb. The error in the log is OS error 64 (the network name could not be found).
Now I've got the customer looking into any reasons why their network may be interrupted overnight, but while googling around I saw someone mentioned that backing up to UNC with databases over 2gb can cause problems? Is there any truth in this?
I am inclined to reccomend the user backs up the database to a local drive and then sets up a scheduled task to copy it across, but I'm interested to see if this is a known issue.
I am attempting to set up SQLCE server tools on my local machine. The installation wizard requires a UNC path to the replication folder (In the NTFS Permissions: Snapshot Folder) . I have tried entering the path as:
Hi All I am a Software developer with around 15 months of experience in .Net 2.0 and VSTO. I am currently working in a SQLServer 2000 project. I feel more interest to work with database than front end coding. Can anyone suggest what need to be done for the one to be a DBA. Could you please provide more details on the roles and responsibilities and the scope for career development on becoming a DBA. In what Timeline can i be a DBA. After becoming a DBA what are the career options available. Please help me out in deciding my career
What is the "prefer" path for moving from SQL 7 to SQL 2005? Please give me the pros and cons for: backup sql 7 and restore it onto sql 2005 vs. migrate sql 7 to sql 2005. In both cases, please give me the pit falls. Thank you.
no results during my search of the web, maybe one of yours can help.
Is there a possibility (during design time is OK) to find out, which TaskHost is before and after a CustomTask (by wiring in ssis-designer) and which type of wire it is (Error, Finish, Success).
Maybe the order of executables is providing this information, when there are no props or methods (and i found none), but then you don't know anything about the type.
