Microsoft SQL Server Forum

My colleagues and I have not been able to successfully set up SQL debugging on a SQL 2000 instance running on Windows 2000. Is there a checklist posted somewhere? We have verified that the SQL Server is not running with System Account Credentials. It runs as a Domain Administrator. We have also verified that everyone has permission to run...

I am trying to find a select on sysprocesses that would list all the active logins. An active login is a login that has a TSQL statment being executed on the server, This didnt work to well! Any ideas. Thanks in advance. select sp.loginame, -- more columns from master..sysprocesses sp where sp.status not in...

Hi I have problem with scheduling tasks. I have one SP, where I decide to fire or not another SP and I prepare parameters for this new SP. The problem is I want to fire this new SP with delay. For example SP1 is executing at 4:00 PM and this SP1 makes SP2 to fire at 1:00 AM. Is it possible to create this programatically ?? Thx for any...

Hi group, I have a select statement that if run against a 1 million record database directly in query analyzer takes less than 1 second. However, if I execute the select statement in a stored procedure instead, calling the stored proc from query analyzer, then it takes 12-17 seconds. Here is what I execute in Query Analyzer when...

I am looking for some papers/information that compare relational databases such as oracle, mysql, sql server etc. I am particularly interested in their features such as locking mechanisms, integrity constraints, views... Anyone know where I can find the information? Thanks, Susan

HI... i need test papers on SQL DB. multiple choice with 3 levels of difficulty: beginner, intermediate and advanced. can anyone tell me where i can get them made? or anyone who can help me with this? any sites... any info will be helpful. thanks in advance.

Hi, I installed MS Data Analyzer 3.5 but it keeps coming up with "Unspecified Error" when loading the sample data "Airline.max". It has run once on another machine but failed after I rebooted. Does anyone know what the problem might be ? Regards,

Folks, My secnario involves two tables - ObservationRegister, and Person. ObservationRegister contains most of the "useful" fields, including the UserID of the person that raised the record, and the UserID of the person to whom the record was assigned for action. I need to write a query to return all values in the ObservationRegister...

Ciao a tutti, devo eseguire una INSERT su un db in remoto...visto che non lo uso frequentemente utilizzo la funzione OPENDATASOURCE invece di linkare il server. Tutto funziona alla perfezione..ma quando sposto il codice all'interno di un Trigger (che lancio dopo l'inserimento in un altra tabella su un altro db) mi dice che non puù aggiungere...

Hi, I'm using MSSQL2000. Is there any way to change the collation of tempdb database? I just realized that my devel and production tempdb have different collation and would like to get them in synch, Thanks, Rolando

is it possible to set a database to the client computers? i am trying to configure how this will work on my client computer but it returns an error agains it. i wanted to create a table/database on my client not on the server. now we executing a query direct to the sql server, i had a great problem when users simultaneously creating a table...

I'm in the process of designing a database and would like some suggestion on how to architect it. I have 3 'objects', frequency, task, skill. For each task there is a frequency however for some tasks there are a number of different skills, each of which have different frequencies, so, for example, imagine frequencies being time in...

Hi, We need help on following things, 1. Inputs on creating comments on the columns & Tables of a SQL Database & generating the sql script of that. 2. Is it possible to call a .exe file in SQL server like following code in ORACLE create procedure CERT_VERIFY_PROCEDURE ( in :X Y by value )

Hello: We've just switched to using Access 2K as the front end to our SQL Server 2K db. Great. Love it. However, one small problem. The users can see the SQL Server tables and veiws but they cannot see the Access Forms or Reports. Since Forms and Reports are not listed in the SQL Server 2K Objects list, you can't grant permissions...

Hello, So my table contains say 100,000 records, and I need to group the categories in fld1 by the highest count of subcategories. Say fld1 contains categories A, B, C, D, E. All of these categories contain subcategories AA, AB, AC, AD,...AJ, BA, BB...BJ, CA, CB, CC...CJ, etc in fld2. I am counting how many subcategories are listed...

Hi all, I have bought Visual C# .NET 2003 Standard and downloaded the MSDE to use with it. I did install it with it's default options and now i'd like to administer it with Web Data Administrator but it keeps telling me that i should enable SQL Server Authentication. So i tried debugging the question creating an .udl file and trying to...

Hi, How Can I create a case sensitive unique index so that A1 and a1 are treated as different ? I dont mind if I have to make a global DB change. Steve

Hello, I plan to create a table with 3 unique keys. Combination of three fields has to be unique for each row in a table that are vendor ID (char 8), vendor name (char 40), and vendor office (5).

Hi, Does anyone know any good book(s) about MS-SQL, especially about Replication - basically, I need in-depth explanation about how to setup/maintain Snap Shot, Transactional, Merge Replication and different agents - with good examples? Hopefully, the book(s) is recent enough to cover SQLCE merge replication as well. In-depth information...

I have an application with highly compressable strings (gzip encoding usually does somewhere between 20-50X reduction.) My base 350MB database is mostly made up of these slowly (or even static) strings. I would like to compress these so that my disk I/O and memory footprint is greatly reduced. Some databases have the ability to provide a...

Hi, Everybody, I'm a Hungarian SQL user and I need a little help for SQL Server 7 ! I protect my table against bad data with a trigger. I use ROLLBACK and RAISERROR statement in this trigger. Users can get my error message after manual input, but the stored procedure always cancel because of ROLLBACK. So the input program dont't have...

This is driving me bananas. Can't find any info on this anywhere.... SQL 2000 seems to replace double space with a single space when I set a varchar field to " " (2spaces), it only stores " " (1space). Why on earth would microsoft do this? If I save 2 spaces - I WANT TO SEE 2 SPACES!!!! Can anyone help? Is this a database setting? Is...

Hi, I am new to XML and need a structure of table in XML format, which needs to be created as a table in another server.The Source and destination servers are SQL Server 2000. Could anyone help me on this. Balaji.S. -- Posted via http://dbforums.com

Hi, I'm doing an Orcle to SQL port. Simply all I want to do is run a script / DTS package that reads Oracle sequences value and writes the current value of it in to a MSSQL table - of SequenceName, Value Can this be done ? If so how ? (Please provide example)

I've got a question that may not be especially appropriate to this group but since it involves a SQL Server 7 job, thought I'd ask. The company I work for has NT4 servers with SQL Server 7 in many of its units. I wrote a vb script which runs just fine on the server itself. I saved it to a folder on the hard drive, ran it, and it did its...