confused here and in need of some help. I have 1 work station that comes up with the error sql native client encryption not supported on the client. When I arrived I noticed that the work stat...
We are having an issue with our MSSQL server after a reboot that the these services won't autostart:
SQL Server (MSSQLSERVER)
SQL Server Agent (MSSQLSERVER)
SQL Server Analysis Services
...
Hi All,
I am getting Event 10036, Office Server Search errors on boot after installing WSS 3.0 with SP2 and search services 2008. Does anyone know what this is caused by? There are a lot o...
Hello,
I am going to configure Log Shipping between two SQL 2000 databases.
I am going to keep the target database in "StandBy/Read-Only" mode.
Let's say the server that hosts the source da...
I can't get the syntax correct when trying to do a multiple CASE statement in this code:
SELECT CASE
WHEN apitem.fcpocat = 'JO'
THEN Left(apitem.fcsojokey,5)
...
We recently moved both our SQL Server 2005 database and Classic ASP coded website from a Windows Server 2003 to a Windows Server 2008, now calls to the database intermittently fail with the fo...
Hi,
I need to get exact difference between two dates in years, months, days.
I try few ideas from internet but its not ok, days are not calc right.
Please for any idea
Tomaz
If I r...
I setup some Maintenance Plans in SQL Server 2005 Workgroup for a Maximizer CRM client last year. When working on their server recently, I noticed that the transaction logs were no longer trun...
Hi,
I want to implement a cascade delete over about 5 tables. I have considered using Sql Server 2005's Cascade delete option on the constraints and would normally do this, but since this i...
Is there much difference, and is it possible to activate x64 with a x86 product key?
I have SQL Server 2005 Express Edition installed, and I want to also install SQL Server Express 2008. I read on various web sites that this absolutely doable. But when I go to download SQL Ser...
Hello,
I have the following scenario:
BEGIN TRAN
INSERT...
INSERT...
UPDATE...
UPDATE...
IF @@ERROR > 0
ROLLBACK
ELSE
COMMIT TRAN
My Second INSERT fails and for some reas...
I'm looking for the connection string, how to open, access, & close a sql server 2005 database using vbscript or a batch file. I have seen examples for the .NET Framework Data Provider for SQL...
Ok. I have a challenging one for you all. But I'm sure for you SQL experts out there is can be done.
I have a client that uses an ERP software (JDE/PEOPLESOFT). We have users setup in SQL D...
Hi
I'm trying to get one of our SQL Server 2005 boxes to query AD to get some user details but keep receiving this error message:
Msg 7321, Level 16, State 2, Line 1
An error occurred ...
i try to connect to datasource through UDL file with SQLConnection, trying to look for correct sqlconnection string for udl file, below does not work
Hi, trying to run stored proc. for the following to insert into table from select query. do I
need a nested SELECT below the INSERT INTO?
Note: the SELECT query works fine, I just cannot get...
I manage a database which was created on a different server and has been restored on my server. The server collation on my server is Latin1_General_CI_AS, but the collation of the database in...
I am using SQL Server 2005 and I have about 250 stored procedures which have been made over the years. Only about 150 of these are actually being used. The problem is, there are so many that...
Hi,
I tried to take the database offline but the process failed saying that it cannot lock on the database.
Afterward, I can't access it. It seems like it wasn't taken offline.
But I don'...
HI
I am using
CREATE USER [karan] FOR LOGIN [karan] WITH DEFAULT_SCHEMA=[dbo]
But I am getting error -- 'karan' is not a valid login or you do not have permission.
Why is it happ...
Please note, the SQL is handled dynamically by the server, therefore some items in my WHERE clause will look odd to you - please disregard this. I am getting the following error and need a han...
We have a SQL server 2005 script that is used to send out a message to a large number of users. The script ulitmately uses EXEC msdb.dbo.sp_send_dbmail to send out the email message.
In read...
Hi
We are running SQL Express 2005 as the DB for Sophos Enterprise and Thycotic Secret Server.
I noticed that Sophos clients were failing to update, so went to check out the Enterprise C...
I use table ProductInfo to display the Product Information in DataGrid (C# webpage, VS 2005).
table ProductInfo contains fields ProductName, ProductDescription, ProductID and so on..
for exa...
