Internationalization Setting - SQL Server 2005

Mar 7, 2007

Is there any setting to indicate Unicode data to handle, so that no need to exclusively use Unicode data types ( ex nvarchar ).
I need to execute both Unicode and non Unicode SQL statements with in one environment. I don't want to create seperate database again.
Please let me know if any one had approached on SQL server this way. I am looking the way Oracle provides where you don€™t need to declare the data type of the column as Unicode type in table definition but can indicate when running a query to manipulate that field as Unicode field.

Thank youSunil

View 1 Replies


ADVERTISEMENT

Sql Server Support For Internationalization?

Feb 20, 2007

Hi, I'm trying to convert our application and support additional east asian languages such as chinese simplified, japanese and korean. I know how to make the asp.net side work by support UTF-8 / global resource files / UICulture and whatever. But what do I have to do on the Sql Server side? I tested a few samples and i'm getting garbage characters after entring some chinese/japanese characters. Another unrelated question, I wrote some custom store procedures (dyanmically concatnated strings), I dont' have sql server 2005, so I'm wondering if I deploy it to sql server 2005, will 2005 be backward compatiable with 2000? I don't have any triggers and stuff, so I'm just wondering if you know anything about it. Thanks.

View 2 Replies View Related

SQL Server 2000 And Internationalization

Jul 16, 2007

We have an existing C# application using SQL Server 2000 database. Currently, the app is English-only, however the business now wants to internationalize the app to support multiple languages (French, Spanish, Russian, Polish, etc.). We will have only one database. So, data in multiple languages will be stored in the same database.



My question is about how this affects the ORDER BY clauses in our SQL stored procedures.



I found an article on Microsoft's web site which seemed to imply that we will have to use COLLATE on every single ORDER BY. This seems crazy to me. If this is true, that means we'll have to pass down a collation name to the stored procedures.



Can anyone clear this up for me?

View 17 Replies View Related

Setting Up A Synonym In SQL Server 2005

Aug 15, 2006

Can anyone tell me why I am getting this error when I try to select * from a table through a newly created synonym? I have admin rights to both db, but they are on separate servers.

<Error>

OLE DB provider "SQLNCLI" for linked server "srvDEV" returned message "Communication link failure".

Msg 10054, Level 16, State 1, Line 0

TCP Provider: An existing connection was forcibly closed by the remote host.

Msg 18456, Level 14, State 1, Line 0

Login failed for user 'NT AUTHORITYANONYMOUS LOGON'.

</error>

<code>

CREATE SYNONYM ARContractTerms_syn FOR srvDEV.EricsAdeptCastle.dbo.tblARContractTerms

SELECT * FROM ARContractTerms_syn

</code>

Am I running into schema problems?

Thanks all



Microsoft SQL Server Management Studio 9.00.2047.00
Microsoft Analysis Services Client Tools 2005.090.2047.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

View 2 Replies View Related

Setting Up SQL Server 2005 Replication

Jun 14, 2007

Hi there



im trying to set up a replication from a local server to a remote server.



when starting up and selecting the Distribution / publisher, i get the following errors --->
Details as followed...



TITLE: New Publication Wizard
------------------------------

SQL Server is unable to connect to server 'SERVERX'.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2050.00&EvtSrc=Microsoft.SqlServer.Management.UI.PubWizardErrorSR&EvtID=CantConnect&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name, 'SERVERY'. (Replication.Utilities)

------------------------------
BUTTONS:

OK
------------------------------
and...



===================================

SQL Server is unable to connect to server 'SERVERX'. (New Publication Wizard)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2050.00&EvtSrc=Microsoft.SqlServer.Management.UI.PubWizardErrorSR&EvtID=CantConnect&LinkId=20476

===================================

SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name, 'SERVERY'. (Replication.Utilities)

------------------------------
Program Location:

at Microsoft.SqlServer.Management.UI.ReplicationSqlConnection.CheckServerAlias(ServerConnection conn)
at Microsoft.SqlServer.Management.UI.ReplicationSqlConnection.Open()
at Microsoft.SqlServer.Management.UI.CreatePublicationWizard.PrepareToShow()

View 3 Replies View Related

Error Setting Up SQL Server Express 2005

Nov 29, 2005

Hi,I had the SQL Server Express installed on my desktop and it was working just fine. Now, I upgraded to .Net 2.0 and I had some problems with the SQL Server Express just like in post http://forums.asp.net/1070169/ShowPost.aspx.These problems were solved by using a cleanup tool but now when i try so setup the SQL Server Express 2005 i get the error:SQL Server Component Update will install the following components for SQL Server Setup:- (ok) Microsoft SQL Native Client- (error) Microsoft SQL Server 2005 Setup Support FilesErrors occurred during the installation:Error 1603 installing Microsoft SQL Server 2005 Setup Support Files.See log file for more detailed information.Fatal error during installation.The log file as lots of information such as:Product         : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install         : Failed Log File        : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0010_WS10170_Support.log Last Action     : InstallFinalize Error String    : The installer has encountered an unexpected error. The error code is 2908. Could not register component {1F3316BE-825B-4390-A9D2-AF3EECCAE9F6}. Error Number    : 2908 -------------------------------------------------------------------------------- WS10170 : There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information. Can someone please help me on trying to avoid format the desktop.Thanks,Stromberg

View 2 Replies View Related

Setting Up SQL Server 2005 With Source Safe

Jul 17, 2006

My manager has asked me to install and configure Source Safe so that our team can check out stored procedures, (and other objects), and check them back in when we are finished working on them.

I'm not familiar with Visual Source Safe. Does SQL Server 2005 work with Visual Source Safe in such a way that I can check out/in SQL Server objects such as procedures?

If someone knows the answer, or perhaps an existing thread that covers this, please let me know.

Thank you for your time!

Frank

View 1 Replies View Related

Setting Network Affinity In Sql Server 2005

Mar 21, 2007

I have recently upgraded my databases from SQL 2000 to 2005. In 2000, I could set the network affinity so that sql server was only accessible from one of the two network cards. I cannot find how to do this in sql 2005. Is there a way?

In my installation, I have two network cards in each server. The "A" network adapter connects to the "A" hub, and the "B" adapter connected to the "B" hub. Traffic on trhe "B" hub is my private, non-routable network, This is where I want the SQL Server traffic to run. The A hub traffic is the public network. This gives me the ability to isolate SQL Server from the outside world.





View 1 Replies View Related

Cannot Connect To To The Other Server When Setting Up Replication In SQL 2005

Jan 2, 2007

Im trying to setup replication between two 2005 standard editions. They are on the same LAN and installed equally + SP1. They are installed as named instances (with the same instance name MSSQL01). Remote access is allowed and TCP/IP and shared memory and I can connect between them.

SQL1MSSQL01 is configured as the publisher & distributor and the snapshot is done. When Im using the subscriber wizard from SQL1 to create the subscriptions and add SQL2MSSQL01 as a subscriber the connection fails to the remote server.

The error message is:

TITLE: Connect to Server
------------------------------

Cannot connect to SQL2MSSQL01.

------------------------------
ADDITIONAL INFORMATION:

Failed to connect to server SQL2MSSQL01. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

When I do a manual connection to SQL2 using the server managemnet studio on SQL1 I cannot connect using the instance name e.g. SQL2MSSQL01, it works only when only using the server name e.g. SQL2. Then I have full access both when using a windows or SQL user.

When trying with using the server name only when setting up the subscription, I got a error saying that I need to use the full name.

TITLE: Connect to Server
------------------------------

Cannot connect to TFMHQARNDE07.

------------------------------
ADDITIONAL INFORMATION:

SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name, ' SQL2MSSQL01'. (Replication.Utilities)

I can also mention that theese servers are cloned from another server and I needed to drop the old servername and add the new servername (sp_addserver) on both servers to get the publisher to work.

When I try to setup the subscription from SQL2 and add SQL1 as a publisher I get the same error.

Any one have any idea what it can be?

View 1 Replies View Related

Setting Up SQL Server 2005 To RECIEVE Emails

Jul 16, 2007

Hi there,



I am looking for a way to have SQL server accept incomming e-mails and store the contents of the e-mail into the database. I was doing some research on the subject of recieving emails from a SMTP server with the server having an account, but it looks like there are no information on the subject.



Is this possible? Or do I have to use some sort of work around hack?



Thanks in Advance,

Liv

View 6 Replies View Related

Setting Up Replication On SQL Server 2000 Using Distributor Running On SQL Server 2005

Jul 6, 2006

Hi

I have a setup where I need to replicate the database which is actually subscribing from another database. The current setup is all in SQL Server 2000. I need to now setup a Distrbutor on a SQL server 2005 and publish the database using this distributor to another server on SQL server 2000.



Has anybody done this before. If yes what will I need to check. Can you please let me know :-



1) SQL Server 2000 which SP should be installed to support this enviroment.

2) SQL Server 2005 which SP should be installed to support this environment.

3) Any thing that I need to look out for.



Thanks for any inputs on this.



Regards

View 3 Replies View Related

Instructions For Setting Up A Sybase ASE Server As A SQL Server 2005 Linked Server?

Dec 28, 2005

I have a Sybase Adaptive Server Enterprise server which I need to set up as a linked server in SQL Server 2005.  The Sybase server is version 12.5.2, and the Sybase ODBC driver version is 4.20.00.67.  I have already installed the Sybase client software on the server.


I also created a SystemDSN on the SQL Server to connect to the Sybase server.  I tested the connection and it was able to connect.

I ran the following code to create the linked server:

<code>

EXEC master.dbo.sp_addlinkedserver @server = N'LinkedServerName', @srvproduct=N'Sybase', @provider=N'MSDASQL', @datasrc=N'Sybase System DSN', @provstr=N'"Provider=Sybase.ASEOLEDBProvider;Server Name=servername,5000;Initial Catalog=databasename;User Id=username;Password=password"'

</code>

I then ran sp_tables_ex to make sure I could view the tables in the Sybase database.  Here is the error message I get:

<code>

OLE DB provider "MSDASQL" for linked server "LinkedServerName" returned message "[DataDirect][ODBC Sybase Wire Protocol driver]Error parsing connect string at offset 13. ".

Msg 7303, Level 16, State 1, Procedure sp_tables_ex, Line 41

Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "LinkedServerName".

</code>

Any ideas what is happening here?

View 10 Replies View Related

How Do I Change The Default Setting From Connecting To SQL Server 2005?

May 2, 2006

Hi there!
My provider does not yet support SQL Server 2005, they are still on SQL Server 2000. I put together a very basic login page, but it is crashing everytime I access it because of this problem, and sadly I am not advanced enough as yet to know how to remedy it! Can you help?
Here is the error page, some of it; - Any ideas gratefully received!
Russ.

Server Error in '/' Application.


An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)Source Error:



An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

View 1 Replies View Related

Setting Permissions In Sql Server 2005 For Asp User Account

May 15, 2006

How would Set permissions  Sql  Server 2005 so that I can access a  asp page created in VWD and Sql Express.
 
On the production server i have just the one instance of Sql
 
I have the following connection string in the web config file:
 
<connectionStrings>
        <add name="ConnectionString" connectionString="server=serversNameXPRESS;uid=aspuser;pwd=aspuserPassworkd;database=DATABName" />
    </connectionStrings>
 
The account i setup to access the db in Sql 2005 Proper on the Production serve is Represented by the name in the above example as “aspuserâ€?. I created this user in security, logins. And  I gave permissions to this on the Db level “create procedure  delete, select, update insert.â€?
 
I get a error when i run the page in the browser that  says “login failed for aspuser.â€?
 
I know virtual directory is configured properly. I can run aspx page in the directory with out a db connection, without and error.
 
Any help would be greatly appreciated.

View 2 Replies View Related

Language Setting On Sql Server 2005 Compact Edition

Oct 18, 2007

Hi!

I have a problem changing the language setting to swedish on sql server 2005 compact edition. The thing is that I'm using a language dependent format: '1998-02-28 14:23:05' (Numeric) when saving and I rather don't want to change this format, because it's a lot of work. (The default setting on the database seems to be us-english, which has the format month-day-year and there by gets wrong for me).

As I understand, this is detemined by the language settings on login. So I set this by using the 'locale identifier' (sv-SE) in the connection string to the CE database, but when I try to save the data, the datum is still interpreted as us-english format.

(The application I'm running have been upgraded from sql compacte edition 2.0 where this worked just fine, though without specifing any language settings in the connection string.)


Appreciate any help!

View 2 Replies View Related

Setting Up SQL 2005 Linked Server Connecting To A DB2 Database

Oct 21, 2006

Hi,

I have setup a linked server to a DB2 database using "Microsoft OLE DB  Provider for ODBC Drivers",

the connections works fine i am able to run select queries.

but the number of rows returned from the two following statements are different.

select * from linkedserver...tablename

select count(*) from linkedserver...tablename

e.g. The First statement returns  116 rows, whereas the second query returns count as 144....

I am a bit confused ?????

could anybody think of any possible reasons..

Cheers

ARAW012 

View 4 Replies View Related

SQL Server 2005 For Two Applications With Different Collation Setting On Same Platform?

Nov 13, 2007

Hi ,

We want to install 2 applications that run on SQL server 2005 but the requirement of database installation are different Collation setting ( One require Dictionary order, case-insensitive, for use with 1252 Character Set and other require Dictionary order, case-sensitive, for use with the 437 (US English) Character set).
So the question here could I install both two applications successfully on same platform ? and if yes how?

Thanks and regards,

Quinh

View 5 Replies View Related

Problem Setting Distribution On Sql Server 2005 Cluster

Feb 28, 2006

I am setting up a clustered sql 2005 to test replciation and I am having trouble setting the server as a distributor. I get the following message

* SQL Server could not configure xxxx as a Distributor.

Only replication jobs or job schedules can be added, modified, dropped or viewed through replication stored procedures.
Changed database context to 'master'. (Microsoft SQL Server, Error: 22538)

Any help is appreciated.

Thanks

View 3 Replies View Related

SQL Server 2005 Express - Setting Sa Password Fails During Install

Mar 21, 2007

During an install of SQL Server 2005 Express setting the sa password does not work consistently. The install is being run as administrator and I am using an .ini file to pass the settings,

SECURITYMODE=SQL
ADDLOCAL=ALL
SQLBROWSERAUTOSTART=1
SQLAUTOSTART=1
INSTANCENAME=DBSERVER
SAPWD=Westtech#1

and while most times it works correctly, occasionally, maybe 4 out of 10 times it fails to set the password and I have been unable to find any warnings or errors in the logs it generates.

We are coming up on release and this is causing us some real problems. Does anyone have any ideas, something I could look at?

Thank you,

Kathy Mook

Westbrook Technologies, Inc.

View 6 Replies View Related

Setting Up Read-only Users. How To Hide Sys. Tables. SQL SERVER 2005

Oct 16, 2006

I need to set up 1 new user in SQL Server 2005 to be able to read specific tables in a db (db1).

The user will connect from MS access using odbc links (SQL Native client ot SQL Server driver)

I've tried to set up one and once logged on from the user workstation, I can only see sys. tables and INFORMATION_SCHEMA tables.
None of the required db1 tables appear.

under Security/Logins I've created User1:
SQL Server auth. with password
default db = db1
server_roles = none
user mapping = map, db1, user1,dbo
securables = none
status = grant, enabled

on the access db, the odbc link was set up with default db = db1

Why can't I see any of the db1 tables?

How can I restrict access to the sys. tables?

Thank you

View 3 Replies View Related

Issue In Setting Up The Database Mirrioring Environment For SQL Server 2005.

Jan 30, 2006


Environment:SQL Server 2005 Enterprise in Win2k3 Enterprise on 32(x86) bit machine
I am able to enable the Trace Flag 1400 using DBCC TRACEON (1400) GO. Only then we can able to configure for the ENDPOINTS.
I successfully configured the ENDPOINTS for both the principal server and Mirror server .And then when I started the START MIRRORING.
I got the error message. Please find the Message below.
An error occured while starting mirroring.
additional Information:
:..>Alter failed for Database 'KQDB', (Microsoft SqlServer.Smo)
:..>An exception occured while executing a Transact-SQL statement or batch
[Microsoft SqlServer.Connection.info]
:..>Database mirroring Transport is disabled in the endpoint configuration.
[Microsft SQL Server,Error: 1486]

If anyone have a solution on how to setup a database mirroring environment.Please send.




View 10 Replies View Related

Setting Sa Password In SQL Server 2005 Express During Install Works Inconsistently

Mar 21, 2007

When installing SQL Server 2005 Express and using an .ini file that looks like this,

SECURITYMODE=SQL
ADDLOCAL=ALL
SQLBROWSERAUTOSTART=1
SQLAUTOSTART=1
INSTANCENAME=DBSERVER
SAPWD=Westtech#1

sometimes the sa password is set correctly, while other times it is not. There does not appear to be any particular environment or system setting when it fails vs. when it works.

We are coming up on a release date and this is causing us a serious problem. Can anyone help?

Thank you,

Kathy Mook

Westbrook Technologies, Inc.

View 1 Replies View Related

Setting Memory Values For SQL 2005 Standard (32 Bit) On Windows 2003 Server 64 Bit.

Aug 3, 2007

Hi,

I am testing SQL 2005 Standard (32 bit) on a Windows 2003 Server 64 bit with 8GB of RAM? Should I enable the AWP Setting or not and should I change the maximum server memory (currently saying 2GB)?

Thanks!
Tom

View 1 Replies View Related

Can Not Setup SQL Server 2005, Progress Stops At 'setting File Security'

Jun 8, 2007

Dear Helpers,



I can not setup SQL server 2005 express and the full trial version as well.



The setup progress stops at "setting file security", and nothing happens. I dont even get an error message.



This is very annoying. I have local administrator access, so it should work. Op system: Windows XP professional.

Machine: Hp Compaq dc7700p, 1 GB RAM, 80 GB HDD



Thanks for your help in advance.

View 5 Replies View Related

Setting Admin Rights To Report Manager, SQL Server Express 2005 On Vista Business

Mar 7, 2007

Hi all,

I'm a newbie to Reporting Services so please forgive my ignorance...

I've recently installed SQL Server Express 2005 with Reporting Services on my Vista Business Notebook (with no network connections) and have installed VS C# Express as well as the Business Intelligence Studio to create reports.

My C# application can connect to SQL Server fine, however, the reports I created with Business Studio refuses to deploy to the server due to the following reason:

"The permissions granted to user 'localhostJenny' are insufficient for
performing this operation".

I find this odd as I've been able to deploy reports on my other Windows XP machine (with SQL Server Express) no probs at all. Additionally, I cannot see the 'Site settings' link within Report Manager (Web) that I'd normally get with an admin account (i.e. on my Win. XP machine). Various sources indicate that my account has insufficient access rights to view this.

Having browsed through seemingly endless blogs and forums, I suspect that my local account has not been configured to access the Report Manager web client to publish, manage and administer the site.

I have tried the surface area tool for SQL Server, but I suspect that this is relevant only to SQL Server DB access and management. Adding an administrator here does nothing.

The question is, how can I grant access to myself (local account) to allow me to publish reports via business studio, and at the same time - administer Report Manager Site Settings - on my vista notebook??

I would be extremely grateful for any help on this matter - I've tried ceaseless reinstallations, but to no avail!


Many thanks in advance,

Jenny

View 5 Replies View Related

Datetime Format Setting --&&> Mm-dd-yyyy Instead Of Dd-MM-yyyy In SQL Server 2005 / Expre(is It With Sql Server Login Language ??)

Aug 26, 2007

I€™m getting a datetime format problem(mm-dd-yyyy for dd-MM-yyyy), when I install SQL Server 2005 Express. {The exception is: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.}
My windows Regional and Language options €“ English (United Kingdom), Sort date format is dd-MM-yyyy.
When converting the date time in Sql server is using the mm-dd-yyyy format. But I€™m supplying the dd-mm-yyyy format date time.

I tried number of things none of them worked for me


1. Tried changing the default language and get the date time format
- exec sp_configure 'default language', 2057
reconfigure
- did not work
EXEC sp_defaultlanguage 'my user name', 'British'
- did not work
(Ref: http://www.cactushop.com/support/UKUS-date-format-issues-with-MS-SQL---conversion-errors-or-blank-pages__592__.htm)

2. Tried a registry hack by opening regedit, and get the following 3 language keys and change it to decimal 2057:
[HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server90ToolsClientSetupCurrentVersion]
[HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server90ToolsSetup
[HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerMSSQL.1Setup]
(Ref: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=62891)
- did not work

3. Every thing in the Regional and Language options to UK and British with the date time format input language keyboard and every think else I could think of, which could link to US English or US date format --------- Did not work

4. even went into the extend of modifying the date format on a Windows machine for new users account by editing the HKEY_USERS registry key and creating a new user - Did not work
(Ref: http://www.windowsitpro.com/Article/ArticleID/39407/39407.html )


5. Uninstall and reinstall SQL server express several time and did the steps 1 €“ 4 where applicable €“ did not work€¦.

If anyone has any idea of what I have to do to change the date time format in the SQL Server 2005 to use the dd-mm-yyyy format for dates....
Please help me or point me in the direction in which I have to look for an answer.
Thank you very much€¦.

View 9 Replies View Related

Setting Up MSSQL 2005

Nov 27, 2006

hi all,

My company has finally decided to go with MSSQL 2005.

now i havent used mssql since version 7.. which was a while ago..

whats the difference in terms of the setup and the easy of use ?

View 4 Replies View Related

Setting Up SQL 2005 Express

Dec 5, 2005

It must be that i'm new to SQL, but i've tried upgrading to SQL 2005 but my views doesnt work?

View 8 Replies View Related

Setting Up And Connecting To SQL 2005

Mar 19, 2006

I have deployed a web server using server 2003 standard edition and have created a functional web site... Now I want to create a SQL data base and make a DB connection using ASP.NET using Dreamweaver as my HTML editor... This is where I get totally lost and confused...I have SQL 2005 instralled on my web server and have gone through the help files and some of the tutes but am still spinning my wheels... Can anyone please help this wanna be MSDN...



I need help configuring my sql server and then connecting to it via dreamweaver and then creating a data base for data collection from my web site...



Any help here would be awesome!

Dadeo

View 1 Replies View Related

Path Setting For SQL 2005

Jun 25, 2007

I used SQL 2000 before. There are options for setting program files path and data path, which I usually install programs on C: and then data files in D: for easier maintenance. However, I cannot find this options in SQL 2005. Is that both (program files and data) must be locate in the same drive/path? or how can I do it same as SQL 2000? Please advise. Many thanks.

View 2 Replies View Related

Setting The Defualt Database In SQL 2005

Mar 28, 2006

Its not a big deal but enoying enought that i always have to

USE MyDatabase

-- Instead of having it set as the defualt and not adventureworks

View 3 Replies View Related

Error Setting Up Distribution On SQL 2005 SP2

Mar 6, 2007

I am attempting to set up Distribution on SQL 2005 using the wizard.

All goes well until the actual script fires off... this line:

use master

exec sp_adddistributor @distributor = N'NAVSOLDEVSQLSERVER2005', @password = N''

GO

Causes this error:

Msg 22538, Level 16, State 1, Procedure sp_MSrepl_check_job_access, Line 155

Only replication jobs or job schedules can be added, modified, dropped or viewed through replication stored procedures.

The rest of the script fails due to this line... Now, I am fair at SQL, but I am no DBA. I did some searching and found one post that seemed to have the same problem, and the gentleman solved it himself, but did not explain how lol.

Any help greatly appreciated!

Dave Borneman

View 12 Replies View Related

Sql 2005 Password Policy Setting

Oct 4, 2006

What are the exact requirements implied by the sql 2005 option:

"Password Must Meet Complexity Requirements "



TIA,



Barkingdog



P.S. I found this one:

-Cannot contain all or part of the username
-Must be at least 6 characters long
-Contain 3 of the 4 following character groups
- A to Z
- a to z
- 0 to 9
- Special Characters i.e. ! ^ $ *


and I have also found

"At least 7 characters in length"

Combines letters. numbners, and symbolds

Is not a dicitonary word, name of a command, person's name or user's account name

As the saying goes "close, but no cigar!"

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved