how do i detect the curret DB?
Sun, 7 Sep 2008 19:04:18 -0400
i need to change the options on the current DB. the first thing i need to do
is alter database "xx". How do i detect the current database name
programatically with a TSQL-script?
Leon
...
|
local connection to SQL2005 Enterprise on a Windows Server 2008?
Sat, 6 Sep 2008 13:46:04 -0700
Hi there,
I'm trying to connect locally to my SQL Server 2005 Enterprise from OS
Windows Server 2008, but it doesnt work. Ive searched on the internet what
the problem could be and i found out that i needed to set some settings in
SQL Server 2005 Surface Area Configuration. But when i clicked on the link
...
|
Linked Server: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON
Wed, 3 Sep 2008 08:55:02 -0700
I'm trying to setup a linked server. The issue I am having is this error:
"Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (Microsoft SQL Server,
Error: 18456)"
Server A is SQL 2005 windows logins only Server B is the same (SQL 2005
windows logins only)
Server A runs windows XP Server B runs Windo ...
|
IIS Windows Authentication Issue. Please Help.
Tue, 2 Sep 2008 12:14:02 -0700
We have asp.net application setup using Windows Authentication. For the
website, under directory security the only thing checked is "Windows
Authentication". We have the users specified in SQL who have rights to
connect...etc. In the Web.Config, it is specified as Integrated
Security=true. However, when the ...
|
OLE DB SQLNCLI "expected data length" error
Tue, 2 Sep 2008 11:21:01 -0700
Msg 7347, Level 16, State 1, Procedure proc_UpdateMetadata, Line 122
OLE DB provider 'SQLNCLI' for linked server '<server>' returned data that
does not match expected data length for column
'[server].[database].[dbo].[ObjectDescription].ObjectNumber'. The (maximum)
expected data length is 24, while the retu ...
|
mirroring database user account problem
Tue, 2 Sep 2008 23:46:20 +0800
I setup a mirroring database, have principal (host A), mirroring (host B),
withness (host C)
i create a user account and login account "usera" can login can retieve data
in principal server (host A)
when occur failover to host B, host B become principal, but i can connect
host B using "usera", i saw host B ...
|
Error3709\ConnectingApplicationToSqlServer2005
Tue, 02 Sep 2008 08:44:07 -0700
I have an application that connects to the db, when it is launched.
When the user tries to login they get the following error message
3709: The connection cannot be used to perform this operation. It is
either closed or invalid in this context.
What could cause this error?
TIA ...
|
|
|
Monitor Linked Server From SQL 2000 using SQLDMO.SQLServer
Mon, 1 Sep 2008 16:18:31 +0200
In SQL2000 I am trying to check my connection to a linked server.
Do you know why I cannot connect using the folloging SQL ?:
-- ADD LinkedServer [MYLINKEDSRV]
EXEC master.dbo.sp_addlinkedserver @server = N'MYLINKEDSRV',
@srvproduct=N'MYLINKEDSRV',
@provider=N'SQLOLEDB',
...
|
Odbc connection doesnt work for named instance
Fri, 29 Aug 2008 11:05:01 -0700
I have a database on sql server 2005, and at times I download a backup
to my local machine for some work. On my local machine 2005 runs as a named
instance (LLCA1-ITE51218\SS2K5), and I have no problems connecting to it with
a sql server account in my asp.net app.
When I tried to run a crystal reports against ...
|
Need a script to detect if sqlserver is down
Fri, 29 Aug 2008 10:35:02 -0700
Hi sql server experts:
Does any one have a script that detect if local sqlserver cannot be connected.
Our sql server sometimes lock itself down due to memory problem. It does not
accept any local/remote connections until we reboot the machine.
It is necessary to have a monitor program that runs in DOS/PERL/PHP ...
|
