Hi All, For SQL 2000: When the user open the database>> Tables, under tables it shows a list of all the ado/sys tables. If user choose one of the table name and right click, there is an option shows the "Design Table". How can we disable that options so that the user can't choose that option...more >>

why is it that this sql statement DECLARE @SQL_BULK_INSERT VARCHAR(1000) SET @SQL_BULK_INSERT = 'BULK INSERT LOGTEXT_STAGING FROM ' + char(39) + 'C:\aaron\ARC_LOGS\LOG_138849.TXT' + CHAR(39) + ' WITH (ROWTERMINATOR = ' + char(39) + CHAR(13) + CHAR(39)+ ',FORMATFILE = ' + char(39) + 'c:\arc_...more >>

Hi, I'm trying to create a link to an Access database in SQL Server 2005 Express. I can do this through Management Studio so it is showing under the 'Linked Servers' branch on the left hand side, however it does not show any of the MDB file's tables, or anything for that matter. I've tried ...more >>

Hi, A bit of background. We have a deployment of CRM 3.0 installed and working fine on our Windows 2003 CRM server in a Windows 2003 AD. Still having problems with clients on Outlook (PC's are not a member of a domain), but playing with the web-based interface for now. Got a problem with...more >>

Sorry if this is not the right newsgroup to out this in (let em know and I will put it in the correct group) We have SQL 2000 standard edition (with the SP4) installed on windows 2003 server. we have transactional replication occuring on a regular basis to 2 servers (1 remote and 1 local). ...more >>

Does SQL server support transcation-scoped variables? I need to save a particular value into a variable (say inside a stored procedure) and then access that variable inside triggers that are run in the context of the same transaction. I need the scope of variable to be limitted to a transaction...more >>

Hi, Is there an sp that displays usage statistics? More specifically, what queries are currently being run or queued, how long it has been running and what connection the queries came from? Thanks. - Komp ...more >>

Could anyone tell me some ways to copy a table( with thousands of rows) from sql server 2000 to sql 2005. Thanks in advance. ...more >>

The SQL services terminate with a fatal error. SqlDumpExceptionHandler: Process 4908 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. * ******************************************************************************* 5 seconds later......more >>

Hi I thinking of getting Microsoft SQL Server Work group Edition 2000 + 5 Clients, English, CD Does this support Indexed views - I seem to think I saw this restriction but cannot find it now.. Thanks ...more >>

I've installed the MS VB Express and WebDev Express and subsequently have MS SQL Server 2005 installed. I'm at a complete loss as to how to access or configure this server. In the SQL Server configuration I can only see how to configure the SQL Express protocols. How can I add users to the ...more >>

I have recently moved from a Microsoft SQL Server 2000 to a SQL Server 2005. In the good old Enterprise Manager, when I imported a table from a SQL server to another, I could choose "Copy objects and data between SQL Server databases". When choosen, all primary keys, and default values was c...more >>

/* I'm having a problem making a select statement to return the correct results. Here is an example of what I'm trying to do. Two tables: @TblNameParts which contains the master list of all the name parts and the MasterNameID which is a pointer to the master record. @TblCriteria which is b...more >>

Suppose i create procedure in DTS and I want to manage call of this procedure from ASP code. How I can manage this. I have SQL 2000 and for me both ASP and ASP.net are interesting\ Thank you -- Aleks Kleyn http://www.geocities.com/aleks_kleyn ...more >>

Team; I have seen this bug about 20 times in the past 3 years. LITERALLY. a) have an ADP open to the queries window b) choose query analyzer on the taskbar c) do something in qa d) select access on the taskbar Do you know what happens?? ADP sits there and automagically fires the spro...more >>

I have been encountering errors on a couple of my SQL Servers and in researching the problem I think that I may need to configure more MemToLeave space. I have not been able to find any articles that suggest how to go about calculating how much MemToLeave I need though. I use AWE to a fixed 5....more >>

My domain host provides Windows hosting, including MS SQL database. Unfortunately it doesn't provide remote connections to their MS SQL server. I can see no method of retrieving my database structure, or the database populated with data, from the hosts control panel. I'm sure that I could u...more >>

Hi, Is there a store procedure or a simple way to find all objects ( sps, views... ) that access a particular column of a particular table? Thanks. Komp. ...more >>

Hi, From a previous sys-admin I inherited a a MS-SQL (2000) machine with 3 instances. It is a nice machine with 4 Gb of memory but the memory allocation is very weird: Instance A: 1400Mb Instance B: 1000Mb Instance C: 80Mb (!) Instance C is performing badly under a bit of pressure which s...more >>

Hi All, I want to pass XML and the data in the XML should be stored in the tables of the database. However, I do not want to use the OpenXML statement. Please let me know. Regards, Shilpa ...more >>

Hi, I have sql server 2005 database. In one of the tables when a record is inserted I want to save the user id from sysusers and the date of insert. So every user has to be able to get his id from sysusers. I use this: select uid from sysusers where name=USER_NAME(). But these users haven'...more >>

....detach and attach? Regard article: http://www.aspfree.com/c/a/MS-SQL-Server/Moving-Data-from-SQL-Server-2000-to-SQL-Server-2005/ I have been trying to do research on migrating our SQL2000 to SQL2005 [on another box] and have not found a lot of helpful information. This article makes it ve...more >>

I created a trigger on a table that sends me an email when records are deleted from the table. I created the trigger about 2 weeks ago. Since then my database has grown at a ridiculous rate. I have deleted the trigger and no longer need it. Is there a way to get my database closer to the size...more >>

Dear all, I have an update statement update ta100d inner join qryholiday on (ta100d.effdate = qryholiday.effdate) and (ta100d.empid = qryholiday.empid) set ta100d.statwrk = qryholiday.ta01ma, ta100d.statwrkdsc = qryholiday.usrdef where ta100d.updusr = 'Y' and ta100d.effdate >= '1060101' ...more >>

Hi, I'm having a problem with the DATABASEPROPERTYEX function... When I run SELECT databasepropertyex(name, 'status') AS Status, * FROM pdxmgr01.master.dbo.sysdatabases order by dbid I'm getting NULL for the Status column. When I look in BOL, there is no value of NULL listed as a poss...more >>

Hi, We have a call to the same stored procedure timing out a few times per day. The sp is executed by some c# code using a SqlDataReader to populate a collection class (all it's doing is assignments (no lookups or anything) -- very fast operations on the mid-tier/c# side). Both the middle t...more >>

Hi I have built an application in SQL Server which is comprised of Employee data. The data contains a category for Division. Divisions are for example: ECT ECT Asia PCT However, I want to be able to put security on the data so that users from each division only have access to their d...more >>

I'm supporting a SQL-based .NET application. What we found is that since this product was installed, overall performance in the morning was good, but afternoon performance is nothing short of awful. In several instances, a mere lookup function consisting of about 130 total records takes over a...more >>

sorry if this is the wrong group. i have admin priveliges on windows server 2k3 server with sql server 2k on it. i want to be able to allow someone else (an account group rather than individuals, preferrably) to be able to log on and still have access to the sql server residing on this pc. ...more >>

I've been searching for an answer to my question quite some time now and I've not been able to figure it out yet. Situation: - I've created a SSIS package containing a bulk insert task. - I've added a package configuration containing the appropriate connection manager (i.e. dev, beta or live)...more >>

It seems from everything I've read that SQL Server cannot control the execution priority (other than deadlock priority) of queries/batches unless you resort to a couple of incomplete, home-grown solutions out there. Okay so stepping back and looking at the bigger picture, what other optio...more >>

I have a table - AccountBalancesBudget which as the following columns: Plant Month Year Amount So take an example of one scenario: Plant Month Year Amount =================== ABC,1, 2005, 2000 ABC,2, 2005, 1000 ABC,3, 2005, 1000 ABC,4, 2005, 1000 ABC,5, 2005, 1000 ABC,6, 2005, 1...more >>

Hello again, Is there a way to not show tables in the Linked Table ODBC connection for a database? Only the Views are marked public for SELECT, but the tables are showing too. The tables are not marked as public. Thanks, Rich ...more >>

Any good newsgroups for Reporting Services? Thanks! ...more >>