SQL Server Sp4 And IPv6 General Question

Oct 3, 2006

Does SQL Server 2000 sp4 work with IPv6?

View 1 Replies


ADVERTISEMENT

IPv6 Support For SQL Server ODBC Driver

Sep 4, 2007

Hi,

I am unable to create the DSN using SQL Server ODBC driver(2000.86.1830.00)by specifying the server name as IPV6 Address.
Here are the steps that I have used to create the DSN.
1. Opened the ODBC Data Source Administrator(Start->Control Panel->Administrative tools->Data Sources(ODBC)).
2. GoTo System DSN tab and clicked on ADD buton, selected the SQL Server driver from the list of ODBC Drivers.
3. Entered the Name and Description.
4. Provided the IPv6 Address of machine in the Server Field. click Next.
5. Entered the SQL Server authentication details. Clicked Next.
6. The wizard poped up following error:
" Connection Failed:
SQLstate:'01000'
SQL Server Error:14
[Microsoft][ODBC SQL Server Driver][DBNETLIB]Connection open(parseconnectionParams())
Connection Failed:
SQLstate:'08001'
SQL Server Error:14
[Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid Connection."

By specifying the IPv6 address as server name I was able to create the DSN in Windows Vista but failed in other operating systems like 2k3 and XP. Could anyone of you please let me know the reason behind the failure of DSN creation? Does the SQL Server ODBC Driver supports IPv6?

View 6 Replies View Related

SQL OLE DB And IPv6

Sep 10, 2007


We have encountered a problem connecting from our client code to SQL Server 2005 using raw Ipv6 addresses.
A small client application on Windows Server 2008 using SQL OLE DB interfaces WILL connect successfully to the raw Ipv6 address of the SQL 2005 Server (also on Windows Server 2008) but the same client will fail to connect if run from a Windows XP or Windows 2003 Server box.

I have seen another post to this forum entitled "IPv6 support for SQL Server ODBC Driver" which would seem to indicate that SQL Native Driver (SQLNCLI) should support IPv6 on 2k3 and XP but that was in the context of a ODBC driver and Vista.

Can we have confirmation from Microsoft that:

SQL OLE DB does NOT support IPv6 on 2k3 and XP?
SQL OLE DB DOES support IPv6 on Vista and Longhorn?
SQL Native Client DOES support IPv6 on 2k3 and XP and Vista and Longhorn?

View 4 Replies View Related

Port Conflict And IPv6-Adress Resolution Errors When Creating Endpoint

Aug 24, 2006

Hello,

executing the first script listed below resulted in the error message (translation):

Message 7890, Level 16, Status 1, Line 1
Error when registrating Endpoint. Potential port conflict ...

use AdventureWorks;
go
CREATE ENDPOINT SQLEP_AWPersons
STATE = STARTED
AS HTTP
(
PATH = '/AWpersons',
AUTHENTICATION = (INTEGRATED),
PORTS = (CLEAR),
SITE = '*'
)
FOR SOAP
(
WEBMETHOD 'PersonInfo'
(NAME='AdventureWorks.dbo.uspGetPersonInfo'),
BATCHES = DISABLED,
WSDL = DEFAULT,
DATABASE = 'AdventureWorks',
NAMESPACE = 'http://Adventure-Works/Persons'
)

I changed the port in the script to 8084:

PORTS = (8084),

Error Message 102: Wrong Syntac near ')'.

I changed the port in the script to '8084':

Error Message 7888: The stated IPv6-Address is not supported. The server is potentially not configured for the IPv6 Connectivity or the address is not formated in an known IPv6-Format.

Could you help?

Best regards,

Wolfgang

View 3 Replies View Related

General Questions About Sql Server

Sep 24, 2006

I asked my tutor those questions and I want to ask you too


Hi
Sir


I hope you doing fine

I
have some questions please;



What is the diffrent between For Attach in Create Database
Command and Sp_Attach_DBWhat is the diffrent between store db file in folder and store
it raw partition e.g. C:What is the useful from TextImage_On in Create Table Command; it
is order Sql Server to stor the photo in diffrent table's fileCan you give us a basic steps to insert *.JPG photo in Sql
ServerIf I have this statement:



Create Table xTable



(
UserId
Int ,

UserName
VarChar ( 3 ) ,



Email
VarChar ( 10 ) Default ( UserId + '_' + UserName )
)



Why This Code not works and how can
I do this without using Triggers.



Can you tell us the different between Media Set and Media Family
and the useful of them. Can we do Backup and Restore Commands on Virtual Tape and How?When I write this code









Create Trigger xTrig on xTable
For Insert
AS

When this trigger will fire Before
Insert, during or after.



What is the useful from EDURE in Create ProcedureWhat is the useful from Recompile in Create Procedure In Sp_AddRole how can I create this role and make the owner
anther person e.g. sa What is the different between User and LogIn in Sql ServerWhat is the different between Role and Group in Sql ServerWhy can I add user to group in Sp_AddUser and I could not add
one in Sp_AddLogin






These lies work good



-- Add
New LogIn to ProgramManagerRole





Exec Sp_AddLogIn 'zProgramManagerUser' , '' ,
'C8_Ahmad_13430_NewSIS' , 'English'
Go

Exec Sp_GrantdbAccess 'zProgramManagerUser'



Go

Exec Sp_AddRoleMember 'ProgramManagerRole' ,
'zProgramManagerUser'

Go



But Why these lines not work good and give me a
msg with an error the Role name or User Name not in the db



-- Add
New LogIn to ProgramManagerRole

Exec Sp_AddLogIn 'zProgramManagerUser' , '' ,
'C8_Ahmad_13430_NewSIS' , 'English'



Go

Exec Sp_AddRoleMember 'ProgramManagerRole' ,
'zProgramManagerUser'



Go

Exec Sp_GrantdbAccess 'zProgramManagerUser'

Go
Thank you

View 3 Replies View Related

Who Shut Down This Server? (was General Question (I Think))

Jan 26, 2005

Is there a way to tell who the guilty person is:

The process winlogon.exe has initiated the shutdown of computer DOCSITE01FDK on behalf of user NT AUTHORITYSYSTEM for the following reason: Application: Maintenance (Planned)
Reason Code: 0x84040001
Shutdown Type: shutdown
Comment:

It tell you that the source is user23. Is there a way to determine who shut down this server?

Thanks

View 4 Replies View Related

General Partitioning In SQL Server 2005

Jan 8, 2007

Ananth writes "A new feature is established in SQL Server 2005. That is Partitioned Table. I went through several articles in net regarding partioned table. But I did not get any generalized version of Partitioning.
For example I partitioned a table into 4 Filegroups based on Transaction Date. So I used range function to give ranges for 4 quarters of one year. It works fine. But I would like to generalize this scenario. It will work for one year. If new year comes ,I have to write new script and execute the same.
The Partitioned function should work for 12 months in a given year. So here year is the paramter and then that function should be construct based on the year automatically.
Can anybody give me answer asap."

View 1 Replies View Related

General Network Error: Is It My Code Or Our Server?

Mar 10, 2007

Hello everyone, this post will be a bit lengthy, so please bear with me.  I've been programming asp.net for abou 2 years.  I'm not a master by any means, and I do things like I learn from books.  Here is my standard way of connection to my mssql database (which is on the same server as my site, so I just use "localhost")  Dim objConnection As New SqlConnection(Application("dbstring"))
Dim strSQL As String = "SELECT * FROM myTable WHERE this='that'"
Dim objCommand As New SqlCommand(strSQL, objConnection)
Dim objDataReader As SqlDataReader

objConnection.Open()
objDataReader = objCommand.ExecuteReader()

Do While objDataReader.Read() = True
'Do what I need to do with the data
Loop

objDataReader.Close()
objConnection.Close()

objConnection.Dispose()Here's my issue. Our website gets this error 2-4 and as many as 6 or 7 times a day: General network error. Check your network documentation.Line ###: objConnection.Open()I use the method I wrote above for getting data on almost every page in the site. Its a HUGE site, but I've made sure that I close all my connections. This is my global connection string:  Sub Application_Start(ByVal sender As Object, ByVal e As EventArgs)        Application("dbstring") = "Server=WWW1;database=###;uid=#####;password=#####;Connect Timeout=300;Connection Reset=False;Pooling=False;Max Pool Size=75000;" End Sub Here's my web.config file:<configuration>    <system.web>        <customErrors mode="Off"/>    </system.web></configuration>... This server has only one website running on it, its a dedicated server. Is there something in my code causing this error to happen so much? We have to restart the sql server everytime this error happens for it to go away. Its very disruptive to the website.

View 8 Replies View Related

General Syntax To Pull Xml Data From A Web Server

Apr 16, 2008



Could someone give me the general syntax to pull xml data from a web server that I have access to? I do know that I can not use an ip address, I have to use the hostname, etc.

I was using something like

FROM OPENROWSET(BULK '\SERVERNAMESHAREPATHDATAFILE.XML', SINGLE_BLOB) as x

instead of using SERVERNAME I am user http:\www.mycompanyname.commycompanynamestoredata.xml

I do not understand why this does not work. I hope I gave enough information for this.

Please help.

Thank you
LadyDee

View 10 Replies View Related

SQL Server Agent &> General Tab &> Mail Session Is Greyed Out ??

Feb 22, 2004

Hi All,

Great forum y'all have going here.

Just wondering if anyone else has experienced this?

Enterprise Manager:
I have setup and 'sucessfully tested a MAPI session' with a mail profile via support services > sql mail. That works fine, however in sql server agent properties the mail session section on the first general tab appears to be greyed out.

scenario is:
Windows Server 2003 SBS edition
SQL Server 2000 SP3
Exchange Server 2003 is also running on the server, with Outlook 2003 client (so i suspect side chaining issue).

Any help appreciated! did not have any luck googling or using microsoft KB.

View 12 Replies View Related

Can't Edit Linked Server General Properties After Saving

Dec 19, 2005

Hi,When I click on the properties of a linked server, all the Generalproperties are read - only, which means that if I want to edit anygeneral properties I have to delete the linked server and recreate it.Needless to say this is a pain. Is this by design or some kind of bug?Is there a workaround?Thanks

View 8 Replies View Related

General Issues Concerning Data Mining With SQL Server 2005

Nov 18, 2006

Hi

I am just starting to learn how to use data mining with SQL server 2005. I have some general questions which I hope someone out there can help me with.

Each month I have approx. 100.000 customers who buy a product.

I want to contact 10.000 of these with a letter for cross-selling some additional products.

Currently I choose these 10.000 randomly from the 100.000 customers. I now want to use SQL server 2005 data mining to choose these 10.000 better, to receive a better response rate. How do I transfer this knowledge to the 100.000 (potential cross-selling customers)

I understand that it could be set up in SQL server like the following:

case table: customer_id, gender, age, city, etc.

nested table: customer_id, product

Is this the way it should be approached and is there a special model/algorithm for this purpose?

Regards,

Dennis

View 5 Replies View Related

SQL Server 2005 Express Edition - General Availability

Apr 5, 2006

Hello,

I want to know the following:

- When will SQL 2005 Express Management tool be out of CTP and be in production?

- When will SQL 2005 Express SP1 be out of CTP and be in production?

Thank you,

Harry

View 1 Replies View Related

General Connection To SQL Server... Done... Grids And Data Retrival ...ugghhh

Dec 13, 2005

Help!!! please!!!... I'm pulling my hair off... Having an external hosting for sql server is terrible for .net. Too many restrictions and they are not willing to help at all... I cannot connect directly, I have to do everything using strings. Honestly and it's a shame to admit it I never learned how to connect using strings, only using the wizard (upsizing DBs from Access to SQL Server)finally, after a month of trying I was able to connect to the database using a string like this:Dim CS As String        Dim db_name, db_username, db_userpassword As String        Dim db_server As String
        db_server = "blah,blah,secureserver.net" /yes, with them >:(        db_name = "DB##"        db_username = "***"        db_userpassword = "***"
        Me.SqlConnection1.ConnectionString = "SERVER=" & db_server & ";DATABASE=" & db_name & ";UID=" & db_username & ";PWD=" & db_userpassword
I am probably not using it right but it's working to capture info using stored procedures but I've been trying to get my datagrids to connect and they are impossible... Any ideas? what would be the coding part of the datagrid/dataset/etc... connection? That probably means that I can't use the property builder or the dataset generator, right?  Any ideas ? Thanks
(using 1.1 Framework)

View 1 Replies View Related

General Advice Needed Regarding MS Access, MS SQL Server, MySQL/PostgreSQL

Nov 15, 2006

I am working on two versions of an application, one of which will be awindows forms application (which will need to be redistributable) andthe other will be a web application.I have MS Visual Studio 2005 (along with the developer's edition of MSSQL Server), but not MS Access. I also have MySQL, PostgreSQL, Sun'sapplication server, Tomcat and Apache web server. I am working onWindows XP Pro, and have installed the .NET 3 SDK and all relevantrelated products I could find (e.g. 2 extensions packages for VisualStudio).I have one MS Access database, to which my users should have read onlyaccess. I have, and have used, a tool for importing MS Accessdatabases into MySQL. I expect that SQL Server has a similar utilityhidden somewhere (where I haven't yet looked, though I HAVE beenlooking - obviously in the wrong places). I have located a similarutility for importing MS Access databases into PostgreSQL. I have notyet decided which servers to use for the web version, but that isanother story, for which I may raise another thread in due course (butI welcome suggestions which may reduce the effort required givenrequired effort for the windows forms app).My problem is for the windows form aplication (intended for use by asingle family). I expect to use ADO.NET. The question is, should Iimport the Access database into MS SQL, and redistribute it, along withMS SQL Server Express (or is that necessary), or distribute it just asan Access database and use the jet engine to access it. A relatedquestion is, "Does ADO.NET support creating new databases for a givenengine?" Imagine a recipe database. It is easy enough to create a SQLscript that creates all the required tables, indices, foreign keys,&c., but can I submit that SQL script to an ADO.NET object, along witha file name, and have it create, e.g., an Access database with thesupplied name. Or do I have to create a database file with nothing init other than the schema?I have more questions, but they'll have to wait.ThanksTed

View 5 Replies View Related

[DBNETLIB][ConnectionWrite (send()).] General Network Error. Occurs When SQL Times Out On New Windows 2003 Sp2 Server

Jul 12, 2007

We just replaced an older Windows 2000 sp4 server with a new Window 2003 Standard Edition sp2 server to run our batch processing. We noticed that when the SQL command times out we now get the following error in the ADO command object error collection.



[DBNETLIB][ConnectionWrite (send()).] General network error. Check you network documentation.

Native Error: 11

SQL State: HY018



msado15.dll version 2.82.3959 is on this server.



On other servers running Windows 2003 Enterprise Edition sp1 the error on the ADO command object is normal with.



Timeout expired

Native Error: 0

SQL State: HYT00



msado15.dll version 2.82.1830 is on this server.



The SQL server they are talking to is on the other side of a firewall. It is SQL 2005 sp2 running on Windows 2000 sp4.



I have also tested this on a Windows 2003 sp2 server that doesn't have to cross a firewall and get the correct Timeout error. It also has the same version of msado15.dll as problem server.



The application is a collection of VB6 Components that are running in COM+ applications. I have isolated the test application to our one SQL interface component and have build a test vbs that can reproduce this on demand. The VB6 Components were not modified in any way for this change and have been working fine for many years prior to this.



All other aspects of our batch processing works as expected. Transactions are working fine. As long as the SQL doesn't timeout everything is normal. DTCPing was used to ensure both servers have correct ports open to allow DTC traffic. Checked the SynAttackProtect setting on SQL and this is not an issue since other clients have no problems.



One point I would like to add is that this new server was initially setup with a temporary server name and then was changed to use the name of the original server on move day. Don't know if this has any impact or not.

View 31 Replies View Related

Urgent : DB-Library Error 10007: General SQL Server Error: Check Messages From The SQL

Jul 20, 2005

DB-Library Error 10007: General SQL Server error: Check messages fromthe SQLServer.CREATE PROCEDURE [dbo].[spu_Import_Export_Image](@srvr varchar(50),@db varchar(50),@usr varchar(15),@pwd varchar(50),@tbl varchar(50),@col varchar(50),@mod varchar(1),@imgpath1 varchar(1000),@pk varchar(50))ASBEGINdeclare @path varchar(50)declare @whr varchar(200)declare @fil varchar(100)declare @cmd varchar(1000)declare @imgpath varchar(800)declare @ext varchar(5)--declare @pk varchar(50)declare @KeyValue varchar(8000)declare @image varchar(50)--declare @imgpath1 varchar(1000)declare @imgpath2 varchar(1000)declare @sellist varchar(2000)set @path = 'c: extCopy.exe'select @sellist = 'DECLARE curKey CURSOR FOR SELECT ' + @pk +' FROM '+ @tbl + ' ORDER BY ' + @pkexec (@sellist)OPEN curKeyFETCH NEXT FROM curKey INTO @KeyValueWHILE (@@fetch_status = 0)BEGINset @whr = '"where '+ @pk +' = "' + @KeyValueset @fil = @imgpath1 + '' + @KeyValue --+ @extset @cmd = @path + ' /S ' + @srvr + ' /D ' + @db + ' /U ' + @usr+ ' /P ' + @pwd+ ' /T ' + @tbl + ' /C ' + @col + ' /W ' + @whr + '/F ' + @fil+ ' /' + @modexec Master..xp_cmdShell @cmdFETCH NEXT FROM curKey INTO @KeyValueENDCLOSE curKeyDEALLOCATE curKeyENDGOAbove srcipt runs fine with image data type in one table but when irun for some other table it gives me Error MessageTEXTCOPY Version 1.0DB-Library version 8.00.194SQL Server 'WSQL01' Message 170: Line 1: Incorrect syntax near '99'.(Concerning line 1)DB-Library Error 10007: General SQL Server error: Check messages fromthe SQLServer.ERROR: Could not use database 'test1'NULL-----------Aslo it only runs on server console if i run it from workstation uingsame files and tables it gives me an error again. Can anybody help meand reply me at Join Bytes! asap.thnx,dharmesh

View 1 Replies View Related

SQL Server 2005 DTS Problem: Error 21776: General Error

Mar 5, 2007

I've recently migrated all databases to SQL Server 2005. I couldn'tfigure out how to create an SSIS package in the time I had, so I juststuck with the DTS packages. They all worked fine during testing, butonce we renamed the server we had problems. The DTS packages stillwork, but whenever I click into the Copy SQL Server Object and try toSelect Objects (on the Copy tab) I get this error:Microsoft SQL-DMOError 21776: General ErrorI click OK and get the error again and again for a total of 12 times(regardless of which database I'm connecting to in the packages, soit's not related to the number of objects in the database). Then theSelect Objects screen appears and it's business as usual.Has anyone else come across this problem and found a solution? I'verenamed the server using sp_dropserver and sp_addserver and select@@servername returns the correct valueJohn Hunter

View 1 Replies View Related

General T-sql Help.

Oct 19, 2005

The following is my code.  What I am trying to do is find all the students a teacher as assessed during a give time.  Then find out which assessment was done the most recently.  After that I will then be aggregating those results.  I have never written any pl/sql or T-SQL... heck I don't even know what to call it!The first sql command is doing what I want it to.  I can only assume the cursor is working correctly.  Any help would be greatly appreciated.BryanALTER procedure Domain@UserID numeric,@StartDate datetime,@EndDate datetime
AS-- Variable DeclerationDECLARE @SessionID varchar(1000)DECLARE @EachSessionID numeric
--Cursor to find all Children that the teacher has assessed for the given timeDECLARE ChildID_cursor CURSORFORSELECT DISTINCT childID FROM capsessionWHERE userid = @UserIDAND sessiondate BETWEEN @StartDate AND @EndDate-- looping through all Children to find there most recent assessment.OPEN ChildID_cursorDECLARE @ChildID numeric FETCH NEXT FROM ChildID_cursor INTO @ChildIDWHILE (@@FETCH_STATUS <> -1)BEGIN IF (@@FETCH_STATUS <> -2) BEGIN  DECLARE SessionID_cursor CURSOR   FOR  SELECT  TOP 1   CAPSessionID  FROM         CapSession  WHERE     (ChildID = @ChildID) AND (SessionDate BETWEEN @StartDate AND @EndDate)  ORDER BY SessionDate DESC END FETCH NEXT FROM ChildID_cursor INTO @ChildIDENDCLOSE ChildID_cursor
OPEN SessionID_cursorFETCH NEXT FROM SessionID_cursor into @EachSessionID SET @SessionID = ''WHILE (@@FETCH_STATUS <> -1)BEGIN IF (@@FETCH_STATUS <> -2) BEGIN  SET @SessionID = @SessionID + @EachSessionID+ ',' END FETCH NEXT FROM ChildID_cursor INTO @ChildIDENDCLOSE SessionID_cursorRETURN @EachSessionID

View 3 Replies View Related

GENERAL QUERY

May 30, 2008

Hi, I wanna know if one has to undergo the 'sql video tutorials' on this website before trying to understand data access tutorials, again on this site.
Are the two related by any chance. Also I am not able to find the customer database files he has created in tutorial # 5, dumb to ask, but what to do?,...so anyone willing to shed light!!!

View 2 Replies View Related

General SQL Abilities...

Jan 12, 2003

Hello everyone,

as you might have seen, I'm a total newbie to this Site and M$ SQL.
I browsed the forum to see if there are already matching answers to my question, with no success.

My question:
As a MySQL & PHP user I ask myself if there is a possibility to use M$ SQL the way I use MySQL and PHP!?
Is there a way to generate dynamic websites with M$ SQL 2000 and a webserver running PHP sources?
A brief yes or no would really help me, if you have any links or resources on this topic, I'd be glad to hear about it.

Thanks
Tom

View 2 Replies View Related

&#34;General SQL Error&#34;

Mar 1, 1999

I get the error "General SQL Error" when reading or writing to a memo field in Sql Server through a frontend build in Delphi 4.
I'm Using the latest BDE.
I have recently installed this onto a NT enviroment in the same manner as my own enviroment but get the error message above.

On my own enviroment and a friends enviroment I do not get any errors.

Can someone please give me some help on this or a direction to run in ?

Thanks

Dave.

View 1 Replies View Related

General SQL Questions

Apr 3, 2008

1. What is the SQL error you receive when you try to fetch data from a cursor after it has run out of data?

2. After a SQL statement is executed, what does a negative value in the SQLCODE variable indicate?

View 7 Replies View Related

General Recommendation

Sep 26, 2004

Hi, folks. I've a production SQL machine with more than 20 users making transactions 24 hrs in 6 days a week. I've only Sunday for maintenance. The server has fixed 2 GB RAM allocation for SQL. Is it good to Restart SQL ( or machine) to clear the Buffer-Cache( or is it good to keep the cache) .... :rolleyes:


Howdy!

View 3 Replies View Related

General DB Help Needed

Mar 16, 2006

:eek: I am not going to lie, I am taking a DB course and am finding it extremely difficult to understand. :o

We are doing Relational DB & ER modeling as well as table normalization.

I only have 1 hour to take an upcoming and know I will score poor on my own.

Anyone want to help me out with my quiz?

I can post the Q's here.

Thanks much

View 14 Replies View Related

General DB Query

May 3, 2004

Hi! How do you query an entire db for a value?

I know how to do table queries from the SQL Analyzer, but not a full DB search.

Like, if I wanted to find a value '137.51 in a DB, what would I use?

Many thanks!

JJ

View 1 Replies View Related

Best General SQL Forum

Apr 28, 2008

I'm not impressed with the speed/quality of responses from this forum...

Can anybody recommend a more active forum?

View 20 Replies View Related

General Search

Oct 5, 2007

Hi,

is there a search function in MS SQL server 2005 to search for a name of a table or a name of field or entry in a field?

what/how should be the fastest way to do it?

thank you

View 4 Replies View Related

General Questions

Mar 11, 2008

Maximum Number of rows allowed in sql server 2005 tables ?
Maximum Number of columns allowed in sql server 2005 tables ?
What are all the built in string functions can be allowed for 'TEXT' DataType in sql server 2005?

View 1 Replies View Related

General Q About Formulae

Aug 3, 2005

Before I go into specifics, this is my problem. I've have a tablethat gets updated with large amounts of data on a monthly basis.Sometimes (rarely) identical rows of data are on one months import thatalready exist from the previous month. I can identify these rows from acombination of two fields (sampleID and testname).My question is this. Would it be an appropriate 'fix' if I created anew 'formula' field on the table comprising of a concatentation ofthese two fields and then made that an index field (no duplicates)? Myguess would be that if we then tried to import a record with a sampleIDand testname that already existed, then the import for that recordwould simply fail.Would this work? Is there a better way? My background is more withAccess so apologies if I'm not using the right terminology.Simon Harris

View 4 Replies View Related

General Question

Jul 26, 2007

hi...i would like to know best practice when assigning a value to a variableexample belowsetorselectdeclare @var1 varchar(25)set @var1='abc'select @var1='abc'to meset is implicitselect implies conditionsi see both used all over the place here at my new company....so witch is better practicetksMJ

View 6 Replies View Related

Which General SQL NG Is More Active??

Jul 27, 2007

Is comp.databases.ms-sqlserver more active thanmicrosoft.public.sqlserver.server, or is it the other way around??Which NG is better for general and 'learning SQL 2005' types ofquestions??Thank you, Tom

View 2 Replies View Related

General Questions

Jul 20, 2005

New to using databases that are NOT Access. New to MS SQL Server. I'dlike help understanding some concepts.Firstly, I'd like to know how to connect to a database using MS SQLServer on a remote web server using Windows XP; I know the IP and havethe username and password to connect...but what program do I use?Suggestions, appreciated.Secondly, I'd like to make changes to the remote database - anyonesuggest programs to use?Regards,OZ

View 1 Replies View Related







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