Today, while working on repairing another issue, I managed to cause an even bigger issue. Of course, I was not smart enough to backup the db before touching it... I have a new instance of SQL Server 2000 running on a Windows 2003 machine. I ran into some issues with logins and, following i...more >>

I have a Windows 2003 server with SQL Server 2000 running on it. The server is performing dual roles as both a database server and a Primary Domain Controller. When attempting to add logins for the server, I see the domain listed twice. This causes any attempt to add a user to fail. I get ...more >>

Hi Is there a way which I can revoke a users ability to view SQL stored procs, but still have the ability to execute?? I want to do this via T-SQL, and without just considering the 'WITH ENCRYPTION' option Thanks ...more >>

Hi I want to programatically attach a DB to an instance of MSDE, and then create the user, and give permissions to the DB I've just attached. I can successfully attach the DB, but cannot get the permissions correct Which sequence of T-SQL commands should I be calling to: a). create the log...more >>

Hello, Is it possible, and if so, how would I do this? I am going to be writing vb.net code that will connect to a sql server that is on a remote machine that is not a part of my local area network, it would involve going over the internet, and run sql queries on this remote sql server. I've...more >>

Hi I have recently read an article which shows how to 'decrypt' SQL stored procedures even though they have been saved with the 'WITH ENCRYPTION' option. This would effectively mean that the encryption does not secure the code to someone who knows how to invoke the decryption. Is there ...more >>

I need to zero fill a quantity value for a field in my table on Insert (ex. 1000 = 0001000). I need it to be zero filled when exporting to a fixed-width text file. I do not need the data type to be numeric. It can be text instead. I have been trying on the select portion of the insert statement...more >>

I accidentally deleted a database from sql2000 on win2003 using the enterprise manager and the check box that asks if i want to delete the history files is selected. my ldf and mdf files are gone and i can't find them in the recycle bin. is there anyway i can recover the database? maybe using un...more >>

I have a column in table that contains several hundred rows of words all in upper case letters. I would like to make them pascal-case instead. Any recommendations on how to do this? ...more >>

Hi, Is it possible to create a custom word breaker for SQLServer fulltext.... I use french word breaker, but for some specific tables, it's not exactly what I want... Seems such a dream will be feasible in SQL 2K5. Please anyone who knows, tell me the truth! :) Thanks, Sylvain H,...more >>

Hi. Let me tell you my domain environment. It's NT 4.0 domain with a Windows 2000 member server running as ASP.NET/IIS/MS SQL 2000, all in one box, and it worked fine. Recently, we bought a new box with Windows 2003 standard version and trying to move ASP.NET and IIS to this box. Howev...more >>

Please help with the right answers on this: The Windows NT user Finance\Angela is a member of Finance\Manager and Finance\Sales Windows NT groups. As a user, Finance\Angela has not been granted any access to SQl Server to any db. However, the Finance\Sales group has been granted permissions ...more >>

Hi, We are going to be running two SQL Server 2000's from the same physical server, with Windows Server 2003, and I need to have certain tables between them syncronized. Database A is a backend to a website and database B is going to be used by a different department. Both the data...more >>

I have a program that creates SQL Server databases. Is there a way that MS Access 2003 can read the SQL database to create reports in Access? TIA ...more >>

Hi I have to upload old data from "Universe Database" to SQL Server. I have no clue how to proceed. I do not know if there's any ODBC driver to do that. All I know right now is there are millions of directories on the server with 3 files in each directory DATA.30 OVER.30 ..Type30 Please...more >>

Hey guys, Have anyone seen DBCC CHECKTABLE ever deadlock with itself? We are running this command every so often to check for corruption (which has been a pain to us over the past couple years). The call itself does spot corruption fairly well when it is present, at least I hope! However ev...more >>

How do I set up my Windows 2003 Server box so that SQL server only listens on the private LAN network card interface? ...more >>

Platform: WinXP SP2/SQL2K SP3 I have an Excel 2003 macro that I am looking to schedule after a series of DTS packages are run. Scheduling the DTS packs using SQL jobs is OK, but when I try to schedule the last job (c:\auto_test_macro.bat), the job hangs and says "Executing Job Step...". Coul...more >>

Hi, We currently have our database outsourced. Once a week I take a manual back of the database to our local server using DTS export. Yesterday I realized we have a table in the database that we no longer use(Table: Products), so I decided to delete it. However, now when I run the DTS ex...more >>

How can this be done? In Enterprise manager, I go through all the steps to select my Oracle Data Source and my SQL Server Destination (Right-Click | All Tasks | Import Data). However, whenever I select a table with a BLOB field, it will not continue with the import. I get a generic, Data Type no...more >>

I got the following question on SQL Server 2000 a couple of days ago (he didn't give me the final answer): There are 3 ways to setup or configure Transaction Logs within SQL Server 2000, what are they? Can anyone help me with the answer to this? I have looked through a couple of reference ...more >>

Hi I have an app which makes good use of SQL Stored procedures. I plan to distribute the app with encrypted stored procs. My question is..... Is it possible to decrypt the stored procs, back to source?? How safe is my IP contained within them? I know that .NET is easy to decompile (prior t...more >>

Hi I need to write a sql server routine to swap tables around - this is quite critical that it succeeds so I'd like to execute this as a transaction e.g. BEGIN TRANSACTION swaptables EXEC sp_rename 'tablea', 'temp_table' EXEC sp_rename 'tableb', 'tablea' EXEC sp_rename 'temp_tablex', '...more >>

Hi I want to call one SQL SP from one to another.... How can I retrieve one SP's results from one back to the original? Thanks ...more >>

Hello, I am trying to connect to an Access database though Query Analyzer. The help file is minimally helpful on this. This is what I have so far: -- add the database as a linked server execute sp_addlinkedserver Library, 'Access 2002', 'Microsoft.Jet.OLEDB.4.0', 'D:\today\Andrew\Libr...more >>

i'm trying to get a user defined function to return something like 12.50 when i pass this function 25 and .5, but all i get is 12.5. CREATE FUNCTION fnCalculateTotalEmployeeCost (@iEmpCost money, @iTotalHrs float) RETURNS money AS BEGIN declare @iItemCost money set @iItemCost = @iEmpCo...more >>

Hi there, I have the following Database: create table big_spenders (cust_id int primary key) create table customers (cust_id int primary key, age int, cust_name varchar(10)) create table orders (ord_id int primary key, cust_id int, date_ordered datetime) create table accounts (cust_id int...more >>

Hi , I'm new to Legato Networker and am trying to get a backup of a SQL server cluster to work on W2K. Have put the -a <virtual server> option in the job an dthe user I'm connecting with is in al lthe relevent groups. Agent is installed on the cluster. But all I get is the following error ...more >>

I'm stumped. What's the trick with using OSQL and Integrated Security? TIA. George. ...more >>

I'm running SQL Server 2000 under Windows 2000 Advanced Server. Authentication is set up as Windows Only. The Administrator account for the server is set up as an SQL user (this is done by default). I'm using the following ASP code to log onto a sample database (for which the Administrator has...more >>

Hey all, I've inherited a project involving many different users at various locations using their own local instances of sql server to access a Database on a single server (a dual-processor workstation). Question: How many connections can a single instance of SQL Server handle? I'm gett...more >>

Hello, I have a User Function with this SELECT ( (I_MASK & 8 ) - 7 ) FROM Permissions WHERE USERID = 6 What does the & in the select statement do?...more >>

i want to list movie titles in alphabetical order, however i dont want 'A', 'The', 'An', etc to be a part of that order, id rather the ORDER BY clause just ignore these words. i cant seem to find any documentation on how to do this if at all possible. please advise..., thanks!! ...more >>

When a nonunique nonclustered index is built on top of a clustered index, is it guaranteed that the bookmark in the nonclustered index will be kept in the same order as the clustered index? Here's an example to demonstrate my question: CREATE TABLE indextest (col1 int NOT NULL,col2 int NOT N...more >>

I have a database that has strings in a description field. I need to be able to search this description field with another text string.. For example, in the second sentence above say I want to search the description field for the string "able to search". This is how i have been trying to ...more >>

When I create a temptable using CREATE TABLE #tmp this table becomes visible in the tempdb database as #tmp_________(...)____a_unique_number But when I try to select from that table I get an error: Invalid object name '#tmp___________(.....)_____________000000000015'. Database name 'tempdb' ...more >>

My device : TOSHIBA Pocket PC e740 Device Operating System : Windows Mobile 2003 Device processor : Intel (R) PXA250 I selected processor Type "arm" (from the list arm, armv4, mips, sh3, wce420x86 and x86) while I install SQL CE in my Pocket PC. I installed without any error. Then I try to ...more >>

Hi, Assuming stored procedure "sp" produces a row set, I want to do something like this: select columns from table where column in (exec sp) How do I do this? Thank you, Bryan ...more >>

Hi I have developed a C# app which uses SQL Stored procs... which I plan to deploy as a single / low user version on MSDE. My SP's all have 'meaningful' names. However, as I want to protect my app as much as possible, is it possible to 'obfuscate' the SQL SP names?? I know I could do this m...more >>

Anybody knows how to show a tool tip when mouse goes over an item in a combo box drop down list ? Thank you, Dino...more >>