I want to get trigger script source from vb6. the database is using sql s开发者_如何学Cerver2000.
I\'d like to consult one thing. I have table in DB. It has 2 columns and looks like this: Name...bilance
I have a user who I want to give readonly access to开发者_运维技巧 an SQL Server 2000 database. I have put them in the db_datareader role, and they can select from tables fine, but when they attempt t
I have to migrate existing data which is in SQL Server 2000 to SQL Server 2005. The schema of two databases is different. For Example Locations table in SS2000 is split into two tables and has differe
I have three tables one of this storing users basic information, the other one is profile information and the last one is storing user picture.
When I run the following query against a MSSQL 2000 SELECT DISTINCT(Email), (SELECT TOP 1 ActivityID FROM Activity aa, ActivityType tt
How to grant view definition for all objects on a database 开发者_StackOverflow社区in SQL Server 2000A user can see all objects in SQL Server 2000: there is no metadata visibility.
This question already has answers here: 开发者_开发技巧 What does the pipe operator do in SQL? (4 answers)
I am running SQL Profiler (the one that comes as a part of 2008 package) for a TSQL_replay trace on a SQL Server 2000 Standard edition database. When I try to open the resulting XML file for a replay,
I have the below Declare @tbl Table(Id int identity, SomeCol varchar(10) not null) Begin Transaction Tran1
加载中,请稍侯......