Rem (12/8/2008)

---

Hi,

I have a sql 2005, where the user seems to be recreated automatically between 5pm and 9pm. This cause a major problem since the rights assigned to the...

waykna (12/7/2008)

---

Hi

I'm in the process of migrating a MS-Access based trading system to SQL Server 2008. I've never worked with SQL server before, nor T-SQL. I have the...

sunandas (12/5/2008)

---

Hi,

We have a production database.There we have made a job of reindexing which runs in any 4 hours.But when this job runs at that time I cant view current...

freddie (12/5/2008)

---

Hi Everyone

I have completed an application that works with SQL Server 2005. There is a particular part of the application (when the user clicks the "release & print" button)...

Yes it will keep the previous instances but this depends on the setup settings, you can also provide...

Mr J (12/4/2008)

---

Hi Guys,

I'm building a test environment to upgrade SQL2000 to SQL2005, i read heaps of doco (most ending with 'good luck') and i've ran the SQL Server Upgrade...

Peter D (12/4/2008)

---

I have a need to update part of a column that has a production UNC path to a specific directory file and need to replace it to a...

Yes as i prefer to perform these task by the use of a function or another stored procedure, and the log...

for example:

here is the sp

Create procedure procedurename

as

select col1, col2 from tablename

now...

Oh really,

One thing we can...

csales (12/4/2008)

---

We'd like to add monitoring of stored procedures to audit/log the following:

- Stored procedure name

- Execution time

- Parameters used

- Date/time executed

Please would anyone let me know if there are...

Gauthama Kolivad (12/3/2008)

---

I am having the sysadmin privileges, ok can be a network problem. Just now i saw my logs an i got this message

The SQL Server has been optimized...

srimkumarp (12/3/2008)

---

hi all,

we having some issues with .net 2008 application.Recently developers developed one appliation in .net 2008.If we configure application in IIS.

It is throwing an error message

Applications developed...

Gauthama Kolivad (12/3/2008)

---

Using this command you can check how many transaction are currently open.

--This command gets you the spid of open transactions.

DBCC opentran

Check how many open transactions are there on...

This is an example only

Excel file : excelfile

userid...