Server Configuration

Reminder - Microsoft Responds to the Evolution of Community
What is Happening? This message is to inform you that Microsoft will soon begin discontinuing newsgroups and transitioning users to Microsoft forums. Why? As you may know, newsgroups have existed for many years now; however, the traffic in the Microsoft newsgroups has been steadily decreasing for the past sev... 20 May 2010 01:56

log shipping file size
Hi, just notice one of log shipping file size is very big(almost 2 GB), normally the transation log file size is 40 MB. How to know more about the big file? Can I track what's transation cause the file big? Please advice. Thanks. ... 20 May 2010 18:20

Update works in one database, but not another
We have two databases on the same Sql 2000 server. They have the same tables, views, procs and indexes. This statement works in one database, but returns an internal Sql error in another: UPDATE Ard SET ard.Applbatnbr ='', ard.ApplAmt=0, ard.CuryApplamt=0 FROM wrkre... 24 May 2010 00:29

Zip SQL Job query
Hi, I have a batch script like this,it works fine If I run it's own. %sivadate%(user defined environment variable) D: CD D:\test\clips(where the makeDirZip.exe is located) makeDirZip.exe i="\\<mserver>\c$\cdc\%sivadate%" debug='no' purge='no' but if I call this batch script in a SQL job it didn't work,it gi... 19 May 2010 10:28

I want full open katrina kaif.
15,999$,WATCH FULL OPEN VIDEO,SANIA MIRZA & KATRINA KAIF how to watch I Dont no 15,999$,FULL OPEN VIDEO,SANIA MIRZA,& KATRINA KAIF wrote: 15,999$,WATCH FULL OPEN VIDEO,SANIA MIRZA & KATRINA KAIF 01-Jan-09 PER MONTH 15,999$ & MORE. WATCH KATRINA KAIF OPEN, SANIA MIRZA,& ALL INDIAN ACTREASS..AND MORE THI... 19 May 2010 08:15

authentication issues?
After a major system failure, and restoration from dodgy backups, I can't get SQLAgent to run. I'm getting event 103, SQLServerAgent could not be started (reason: Unable to connect to server Well, the server is running, and the website is running, and I can connect using OSQL, so I figure perhaps it is an auth... 19 May 2010 08:15

SQL Server Edition
Hi Experts I have serveral SQL Server and many instances under each server. I have problem in finding what are the editions of each instance. I know the following techs 1. SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') (T-SQL and ADO) 2. select @@V... 18 May 2010 21:27

For SQL Guru, create a trigger
I've 2 tables: CREATE TABLE [dbo].[DM]( [ID] [int] IDENTITY(1,1) NOT NULL, [IDDi] [int] NULL, [IDMa] [int] NULL, [Activated] [bit] NULL, [ConcurrencyId] [timestamp] NULL, CONSTRAINT [PK_DM] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = ... 18 May 2010 18:09

Backup Analysis databases
Hi, How can I backup Analysis databases I backup SQL Server databases with maintain plan Not found the same for Analysis databases ? Thanks in advance ... 18 May 2010 17:02

NOLOCK on View / Stored Procedure in SQL Server 2005
I have a SQL Server 2005 database that was several stored procedures and several views. Will the stored procedure listed below with the NOLOCK statement not lock the dbo.Team table? The stored procedure has numerous other processing details but I took that part out of the procedure. My goal is to make ... 18 May 2010 19:16