administration

Can we write triggers on system tables

• by gvphubli

• Other

• Topic

Hello experts can I write triggers on system tables I tried to write by it gave an error .. is there any way out.

2001-09-17

2 reads

Using sp_MSforeachdb in SQL6.5

• by sftey1

• SQLServerCentral.com

• Topic

I was trying to use above mentioned stored procedure but hit the following error : Msg 229, Level 14, State 2 SELECT permission denied on object #SQLOLEDbUserProfile00000000F6, database tempdb, owner dbo Any idea how to solve it ?

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2001-09-17

6 reads

DBCC SQLPERF (Logspace) Reporting Internals

• by Additional Articles

• Other

• Administration

• Article

This is a broad overview of the DBCC SQLPERF command primarily for version 7 and 2000.

2001-09-17

1,927 reads

• Discuss

Support for Network Database Files

• by Additional Articles

• Microsoft MSDN

• Administration

• Article

By default, network database files are not supported with Microsoft SQL Server. Here's a workaround.

2001-09-14

1,145 reads

• Discuss

Running a DTS Package in a trigger

• by binduram

• SQLServerCentral.com

• Topic

When I update a column xx in table A the query hangs because of the FOR UPDATE trigger This is the trigger: CREATE TRIGGER aTrigger ON A FOR UPDATE AS IF UPDATE(xx) EXEC master..xp_cmdshell 'dtsrun /Sservername desk /Ndtspackagename /Uauserid /Papassword' On its own the EXEC command runs okay with the userid and password, but when […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2001-09-13

2 reads

Created DTS in 2K need to run on v.7.0

• by joe_sladek

• MSDN Communities

• Topic

I've created a DTS in SQL2000 that isn't recognized by SQL7, in short, it won't run the job created in the SQL7 environment. Is there an issue here? Joseph L. Sladek

2001-09-12

2 reads

TSQL - Encoded Characteristic Functions

• by PJCina

• SQLServerCentral.com

• Topic

A few years back some training emerged on someting called Encoded Characteristic Functions(ECF) The training is offered by DCI (Digital Consulting Institute (formerly Digital Consulting Inc.) I would like to hear from anyone who has taken it on it's usefulness, relevance to SQL 2000.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2001-09-10

42 reads

SQL Server Stored Procs under SourceSafe

• by ravi_sachdev

• SQLServerCentral.com

• Topic

Hi, I am trying to place a SQL Server 2000 database under source code control. 1. Create a Data Project under Visual Interdev to connect to this database, following which I can see all the tables/views/stored procs, etc. 2. Place the Data Project under Source Code Control by right clicking on the Connection in the […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2001-09-10

3 reads

Using COM to Encrypt Passwords

• by Rahul Sharma

• Other

• Topic

Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/rsharma/comencrytptpw.asp

2001-09-09

3 reads

Automating bckups

• by parasu

• SQLServerCentral.com

• Topic

Hi all, I can backup my databases into my local drives. But, if I'm moving my database bkup from the local machine to another mach from where I do a tape backup, can this entire process be automated? Cheers Parasuraman Parasu Raman

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2001-09-08

2 reads