all groups > sql server connect > october 2006 > threads for october 1 - 7, 2006
Filter by week: 1 2 3 4 5
Specifying which SQL Server to use
Posted by Todd Cary at 10/6/2006 6:24:57 AM
Under SQL Server Group, I have three registered servers:
(local) (Windows NT)
192.168.100.5 (Windows NT)
2K-SERVER (Windows NT)
Each server contains a database named "Admin" and each "Admin"
database has a table, "Cases".
In the following query, how would I specify the Server:
SELECT... more >>
Accessing a remote SQL Server
Posted by Todd Cary at 10/5/2006 2:38:26 PM
Currently, I access a database and table that is not the current
database using Admin..CASES
INSERT INTO Admin..CASES
(CASE_CODE,CASE_NAME,CASE_CLASS_PERIOD_BEG_DATE,CASE_CLASS_PERIOD_END_DATE,
CASE_DISTRIBUTION_DATE,CASE_URL) SELECT M.MailCode AS
CaseCode,C.CaseName, C.ClassPeriodBegDate... more >>
SQL 2005 Windows Groups Authentication - Cannot open user default database. Login failed
Posted by craig.overton NO[at]SPAM gmail.com at 10/5/2006 10:56:45 AM
All,
To start off I have SQL 2005 SE Clustered in an Active/Active
environment. Everything is working correctly as all websites and
standalone applications are connecting and getting/sending data
correctly using SQL authentication.
My problem is that I have 1000's of developers that would l... more >>
DNS problems in ASP
Posted by FilMar at 10/4/2006 1:02:52 AM
I hope that I'm right here.
We have an intranet-site in ASP where, till now the data was in an
Access database and we connected to the data via DNS.
Now we would like to change the data to a SQL-server.
For me, it seems logic that logic that everything should work after
creating a new DNS t... more >>
mssql backup/dumpfile
Posted by Suter at 10/4/2006 12:00:00 AM
Hi
I'm using the free MSSQL Database from Microsoft and the SQL Server
Management Studio express to administrate the datas.
However, I'm looking for a possibility to backup my datas. Of course it
should be a no coast backup way;)
If I'm not totaly wrong then I can't make a backup or a dump... more >>
Connectio to Remote SQL Server from another SQL Server Stored Proc
Posted by Esteban at 10/3/2006 2:19:02 PM
Hi,
I have a problem with a conection to Remote SQL Server Database wich have a
blank space in databese name.
Ex.
"Production ED"
I Can`t change the name of this data base.
I Need to connect this database with a Stored Procedure in another Server.
Both Databases are SQL Server 2000... more >>
|