Hi;
I feel like an idiot to be asking this,
but how do I change the default drive and folder
in which new databases are created?
I've been looking all over Server Mgmt Studio,
and I can't find anything. I'm thinking that someone
can tell me this off the top of their heads,
or slip me a link to a web page.
Thanks,
Hey Community,
What are the guidelines for installing the SQL Software? Is it bottleneck if both Windows and SQL software are installed on the same drive ( I have all the database .mdfs and and .ldfs on a seperate RAID array)?
thanks,
Saptagiri Tangudu
PNT Marketing Services
hi all
when my snapshot folder is on a network drive, on which "simple filesharing" is enabled, i can access that folder without typing a user and password and configuring login security settings.
but in fact the network drive on which the snapshot folder will be located will do have a login and password. (when i go to it with windows explorer, i have to enter my login and password).
won't this cause problems for the replication? as i don't see where to enter net network login when i configure the replication via the wizard.
Thanks for help
Hi guys. I'm new to MySQL..
I've just installed MySQL on drive C: of the server, but now i need to change it from drive C: to drive D:. Is there anyway of doing this?
All,
I have a test server that needs the drive letters changed for the data, log and backup drives. Is there a way to make this change without reinstalling SQL Server?
Future guru in the making.
Hi there. I have to change the drive letter where SQL server have hisdatfiles (master included). If I do that, ob the SQL fail to start, becouseit's unable to find the master datfiles. Is it possible changing driverletter without reinstalling the complete product?BRamnésia
View 2 Replies View RelatedCan I change the folder that the databases reside in for my installation of SQL Server? I would like to have them in a folder on another drive, but I can't seem to find where the path is configured.Any help is appreciated.
View 4 Replies View RelatedI am wondering how I could do the following -
Right now the default folder is Home, what if I have two users User1 and User2, my folder structure is the following -
Home/User1
Home/User2
I want each user to only have access to their folder. That is easy to do.
Once both users have proper access to their folders they still don't have access to Home folder. In Report Builder when I do 'open file' it defaults to Home folder so I get an error. How can I specify the home folder to be User1 for that user and User2 for the second user? I know I can give them both browsing permissions to Home but it's not very elegant.
There must be a way to programmatically change the folder as soon as proper user logs in. Anyone knows how to do that?
Thanks.
i had installed Sqlserver on drive E: before but i changed the drive letter to D: yesterday and now i can't start my sql server. how can i fix this problem?
View 1 Replies View RelatedHi everyone!
I have a problem regarding the generation of report using SSRS (SQL Server Reporting Services). As I've read from other forums, the said service need access to the Windows temp folder, which by default, is found in C:WINDOWSTemp. The said path is found in either the TMP or the TEMP environment variable.This means that there should be sufficient access to this folder, in order for SSRS to properly generate the report. The problem is that my client, for security reasons, does not want to grant special rights to this folder, using the ASP.NET account. Is there any way that we can change location of the temporary folder being used by SSRS without having to change the value of the TMP and TEMP environment variables? thanks in advance
Ive just installed VS2005 Pro and SQL Server Developer edition.
Now I want to set the default paths for project, templates, settings. But I want for both VS and SQL files.
For example, right now the default folders for SQL Studio are:
.My DocumentsSQL Server Management StudioProjects
.My DocumentsSQL Server Management StudioSettings
.My DocumentsSQL Server Management StudioTemplates
.My DocumentsSQL Server Management StudioBackup Files
... and so on.
For VS Studio:
.My DocumentsVisual Studio 2005Projects
.My DocumentsVisual Studio 2005Templates
.My DocumentsVisual Studio 2005Code Snippets
... and so on.
I would like for all sub-folders(from SQL Server and VS) to be in one same folder(Development), for example:
.My DocumentsDevelopmentProjects
.My DocumentsDevelopmentSettings
.My DocumentsDevelopmentTemplates
.My DocumentsDevelopmentBackup Files
.My DocumentsDevelopmentCode Snippets
... and so on.
I have tried changing in each application´s options the default path for each one, pointing to each folder I listed above.
My problem is that both VS and SQL Server still keeps creating folders in the old locations, for example: ".My DocumentsSQL Server Management StudioProjects". This example happens when I create a new query, and try to save it, it automatically creates that folder.
It only works for a few of them, like the settings folder. Ive managed to create a single folder for SQL and VS setting files.
Is there a way I can join both Application folders? I want to keep both projects files in one folder, both setting files in one folder, and so on...
I hope I explained well my situation.
Thanks!
Hello, when I log onto Report Manager web server using Windows Authentication, I need this user to be directed to a default sub folder.
For example: if I have folder A and sub folder 1 and 2. I need to be able to log in and be directed to sub folder 1. I was able to set up view role and access folder A. But then I need to click on folder 1 to view / create my reports.
Sql server 2000 was installed to a default folder C:Program FilesMicrosoft SQL Server
And sql server 2005 was installed to the same location C:Program FilesMicrosoft SQL Server
how do i know which files are related to 2000 and which are related to 2005
please let me know
I have a merge replication. Currently works fine. Publisher & Distributor are on the same server. I need to change the location of the alternate folder for the snapshot files.
I’ll probably just change it through the GUI, but would I use sp_changedistpublisher or sp_changemergepublication if I were scripting everything?
My real concern is the subscribers. Do I have to ‘tell’ the subscribers where the alt folder has been changed to? Do I just run sp_changemergepullsubscription on the subscribers?
In SQL Server 2012 Instance properties ,database default location is not showing system drive E: which was my backup drive. How can I add it again?
View 8 Replies View RelatedHow can you install the System Databases to a drive other than the default?
I want the Data Files to be installed on D:MSSQLData and the log files to be stored on D:MSSQLLog.
For better, quicker answers on T-SQL questions, click on the following...
[URL]
For better answers on performance questions, click on the following...
[URL]
I have system database and user database file are present in G,H and W drive.The process is going to be - copy data from G to S, H to T, W to U. Rename G to X, H to Y and W to Z. Rename S to G, T to H and U to W. Reboot the servers. The original G, H and W will then be X, Y and Z. The old S will be the new G, old T will be H and old U will be W. My question is that after doing this whether my SQL server will start or not
View 8 Replies View RelatedHi, can anyone help me please - I'm still struggling with my database.
My set up is: Microsoft Visual Web Developer 2005, SQL Express 2005, GoDaddy windows shared hosting.
On my PC I have a site which uses membership and the default database which was created after first compilation.
This works fine locally.
However, I need to export this to the GoDaddy server.
To do this I must rename the database (or recreate the project with a newly named database) and figure out how to alter any other settings.
I tried running aspnet_regsql.exe command but I really didn't have any luck.
I would have thought this would be a straight forward operation.
Can anyone give me guidance please.
Garrett
Hi ,
Can someone please help , we are trying to change the default language
from us_english to british englsish as the date formats have to be in dd/mm/yyy for our european clients.
We tried sp_configure 'default language' 23
Reconfigure . It worked 3 months back.
We are trying this on the reverse , now and it doesnt work.
Can some one please Help !! Its Urgent !
Thanks in advance
Nat
Does anyone thing it is a wise thing to change the default port for SQL? Will this adversely affect the server? Thanks.
View 2 Replies View RelatedHi.
I thought I had this solved but after running aspnet_regiis again
I am having the same problem.
I can't log onto my sql server because the default DB is master.
The following command using sqlcmd gives me the master db:
Code:
SELECT *
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
GO
So, to try to fix this i ran:
Code:
EXEC sp_defaultdb 'sa', 'my_default_db'
GO
and no luck. I went over to the DB server and checked
the permissions under SERVER/SQLEXPRESS > SECURITY > LOGINS. All except NTAuthority and Administrators have
my intended DB as the default (including ASPNET).
This is frustrating because I know I have figured it out
before but I can't remember what I did. Help appreciated.
Thanks.
Does anybody know how I can change the default value for a column?I was trying to remove the default value in order to add the new oneafterwards. This is what I tried:alter table /table-name/ drop default for /column-name/alter table /table-name/ alter column /column-name/(/new-decl-without-default/)It did not work. I cannot find a solution in the documentation. Maybeyou can help me out?Thank you,Johan
View 4 Replies View RelatedA few weeks ago a client asked me to add a column to a table so Icreated this script:ALTER TABLE dbo.tblIndividual ADD fldRenewalStatus BIT NOT NULLCONSTRAINT fldRenewalStatus_Default DEFAULT 0Now they want to change it from a BIT to an INT, to store an enum.Fair enough. However, no matter how much I wrangle with a script, Ican't find a reliable way to alter the column. I've mixed and matchedthe following and nothing seems to work:EXEC sp_unbindefault 'tblIndividual.fldRenewalStatus'DROP DEFAULT DF_tblIndividual_fldRenewalStatusALTER TABLE tblIndividualDROP CONSTRAINT fldRenewalStatus_DefaultALTER TABLE tblIndividualDROP COLUMN fldRenewalStatusGOALTER TABLE tblIndividualADD fldRenewalStatus int NOT NULLCONSTRAINT fldRenewalStatus_Default DEFAULT 0Thoughts?ThanksEdward
View 4 Replies View RelatedHow can i change the default value of a column? I already have a columnnamed DateOfRental but I want to alter it so that it has default valuegetdate()ThanksDavid--http://www.nintendo-europe.com/NOE/...=l&a=Prodigious
View 4 Replies View Related
Hi,
I've created a new Stored Procedure template and saved it to .Microsoft SQL Server90ToolsShellTemplatesSqlStored Procedure. I can view (and use) the template via the Template Explorer, however, I want this new template to become my default template.
What do I mean by this? - I want to be able to right-click on stored procedures in my object explorer, click New Stored Procedure, and be forced to use my new template, rather than Create Procedure (New Menu).SQL.
Thanks
Jon Derbyshire
Hello,
Our security center just scanned my database server and has asked that I change the database server from the default instance name and change the default port used. When installed MS SQL Server 2000 I used the default installation settings. I have installed SP4 and this is all running on a fully patched WIN 2003 Server machine. Is this possible without un-installing and then re-installing?
Thanks for any and all help.
Ben
Best practice talks about the use of name conventions in the SSIS packages.
Is there a way to rename the default names of the tasks in the DataFlow and ControlFlow once and for all, so that each time I drag a new DataFlowTask in, the default name will be DFT and so on.
Hi, I'm supporting a SQL 6.5 application through a firewall & I'm new to NT & SQLServer.
What's the easiest way to find out what port SQL is listening on? It should be 1433 but
the NT guys say 1433 isn't in use. What's the easiest way to change the default port? A search through Books online talks about editing registry keys & I'd prefer not to do this if this can be avoided. Any tips would be appreciated.
If you enter "Create Database test", the database files (mdf file & log file) are created, by default, in:-
C:Program FilesMicrosoft SQL ServerMSSQLData
I want to change that to:-
D:Database Files
I sucessfully moved the model database to this location (using the instructions in BOL) assuming that all new databases would now get created in the same location, but they don't. They still get created in:
C:Program FilesMicrosoft SQL ServerMSSQLData
So how do I change the default?
(It's not satisfactory to have to move each database after it's created)
Thanks, Andy Abel
I am creating SSRS reports on top of SSAS cubes. I want the default value of parameter to change dynamically based on the current year or it should select the last of the parameter values.
Can this be done?
I have installed my modell database onto c:mssql7data...
How do I now change the properties of this so that when someone creates a database, the path it will get created to is set to d:
I thought that I could just move model, but it seems that this isn't possible.
Any advice?
thanks
derek
Hello,I have SQL Server 2000 Enterprise Edition, and I'd like to change thedefault port to something else (we'll use 2033 for this example). I'vetried to connect from another computer on the same subnet using"ServerName:2033" as the server, but it doesn't connect. It will connect ifI change the Server to use the default port and change the server to connectto on the client to "ServerName", but either I"m not referencing the newport number properly or ????Any help you could provide would be great.Thanks In Advance!Rick
View 1 Replies View RelatedI want to change the default directory for my stored procedures. It is extremely inconvenient for me that they are placed in documents and settings... I cannot find a place in the Tools where I can change it.
Thanks.