Since It is not possible to have a trigger on system tables or information_schema views (?), is there an alternative? I want to detect (trap) a change to a column in SysJobs table. thanks ...more >>

Do any of you know any public forums or non-MS sites dedicated to Reporting Services? Thanks....more >>

Is it possible to call a .DLL or execute some command when a trigger is fired? Thanks ...more >>

Now I face a task. I need to transfer all logins of an old SQL Server to a newly installed one. I mean the server logins under Security\logins in SQLEM. It is totally tiresome and error-prone to do this manually. Is any way to write a simple (or complex) SQL script to do this? Thanks. ...more >>

Hi SQL Gurus, I have Table A with PK on a,b,c,d (so I have index on this) Table A has FK on (a,b) to Table B) Table B with PK on a,b I have questions : (1) On Table A, what queries that can make use of the Index (2) On Table A, Do I need Index on (a,b) for the FK T...more >>

How fast is SQL-DMO at retrieving SQL Server database chema info compare with other methods such as ADOX? What other methods are available for this purpose? Ben Fidge ...more >>

How can I disconnect all user which are connected to specific database? ...more >>

How can I learn (try) new upcoming SQL Server version? Thanks ...more >>

Hi All WIN 2kpro SQL 2k dev ed, I use something like this SELECT count(fieldname) From MyTable the correct result is fine but I keep getting a warning sent back as an error to my asp. how do I stop the warning warning: Null value eliminated from aggregate. thanks for any help/tip...more >>

Is it possible to make two columns in one table as a primary key ? each of them has duplicates but the combination of the two columns is unique. if possible how to make it. ...more >>

Hello All, I can not find in BOL the maximum buffer size allowable by the output parameter in xp_sprintf? From some simple experiments, the function seems to handle character buffers up to about 255. Anybody know if the buffer size can be resize for a larger strings. Thanks, Mike M ...more >>

Each SQL Server database should correspond to one IP address. I assume web server and database server are in separate machines. Here's 2 cases: case 1: A single web site have data access to the SQL Server database. case 2: There are multiple web sites need to have data access to the same SQL...more >>

I want to restore database from my application with RESTORE DATABASE work FROM DISK = 'c:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\work.dat' but I get error "Exclusive access could not be obtained because the database is in use." Can I do something to avoid that error? Maybe I ...more >>

My app receives a set of files from another location, and I need to update and add records in my database. The database is used for interactive data entry normally, and the batch update happens a few times a month. The largest batch contains a dozen files (updating/adding to corresponding tabl...more >>

On a 7.0 server, I get the following: Server: Msg 252, Level 16, State 1 Cannot group by a bit column Why does this work on a 2000 box and not 7.0? Suggested resolutions?...more >>

Hello, How would I write a query on this sample table to produce the xml output below? Thanks. Create Table test ( CustomerId int , LName varchar(50) , FName varchar(50) , MI char(1) , SSN char(11) , StreetAddress varchar(50) , City varchar(50) , State char(2) , Zip char(5) ...more >>

From within a Stored Procdure, how can you get the results of a dynamic query? Here's what I would like to do, but it does not work: SELECT @nextUniqueID = EXEC('SELECT TOP 1 UniqueID FROM ' +@tmpTableName) Any help greatly appreciated. Yes, this query must be dynamic. Thanks a lot. ...more >>

Hi all, I have built a web based application for a client, their host allows them 20mb of database 'size'/'space' etc - anything over that is charge for etc... I checked the database size the other day by right-clicking on it and it quotes 554mb! I *think* this is probably made up from t...more >>

Hi, I have a select statement that selects a datetime field from my table. I want to be able to have this to be in the format of 'Sunday, November 2,2003' (or similar). Is there some sort of format command I can do within the actual select statement, to do this ? THanks ...more >>

I get the error below when I try to run this query: SELECT EntityID, MIN(TransTime) AS LoginTime FROM YourTable GROUP BY EntityID ORDER BY Min(LoginTime) DESC Server: Msg 207, Level 16, State 3, Line 1 Invalid column name 'LoginTime'. How do I order by the newly ...more >>

Hi, How to select records from index n to n + 2: select * from products; //?if n= 5, only need to return 5-7 records back. Thanks... ...more >>

Is there any way to update a datetime column to null? I have an application where a user enter information about projects. There is a field Finished date. How can i manage the case when the user enter a date in that field, the table is updated, and later on decides that the project hasn't been...more >>