What is best practice for setting up counter logs in performance monitoring? Is there such a thing? I had three counters setup to take a reading every 15minutes and got I yelled at for straining the system and I should not be saving to the same server. I only setup those monitors for which...more >>

I have 1 table (named Categories) with CAT_ID and name etc., and another table (named CatHierachy) that has 2 columns, P_ID and C_ID, and that links the categories to each other, creating a tree of categories and sub-categories and sub-subcategories. I made the following update query in Acc...more >>

I'm moving a db from serverA to serverB. I detached the db on serverA and copied the files to serverB. I want to change the file names when I attach it on serverB. How can I do this? If I try to change the name and attach the db, it doesn't like the renamed files; it will only let me attach a...more >>

..... in SQL 2005 ??!?!? Pensavo fossero la stessa cosa ma ora non credo più... insomma ho un po' le idee confuse a riguardo. bye Grazie. ...more >>

Given these facts: - There are some legacy applications that use DB-Library (ntwdblib.dll) to connect to SQL Server - There are now free SQL Server editions like MSDE and SQL Server Express, and both are supposed to work with the DB-Library - There is a need to use those legacy applications t...more >>

Login failed for user ''. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452) SQL authentication works fine. 4 of 50 people have this issue connecting to any sql server in another domain (I would guess a one way trust as it is a staging doma...more >>

Hi there I have a stored procedure which uses a table variable which is declared as follows: DECLARE @VtblResults TABLE ( [ROWID] INT IDENTITY(1,1) NOT NULL PRIMARY KEY ,[ClientID] INT NOT NULL ,[ContactCardID] INT ,[Name] VARCHAR(500) ,[DateRequested] DATETIME ,[DateSent] DATETIM...more >>

I have two tables. Employee and Time. These 2 tables link together by their EMP_ID field. Basically I need to update the DEPARTMENT field in the Time table to be the same as the DEPARTMENT field in the Employee table when The EMP_ID fields match. Just not quite sure how to write this Updat...more >>

Hi, In SQL 2005, with SQL Clustering: 1. Can a THREE-node active/active/active cluster be setup? If yes, is setting up a three-node a/a/a cluster recommended? Any pitfalls or gotchas that one needs to be aware of? With Replication: 1. Can a subscriber in turn be a publisher to another su...more >>

Our users all have access to our DB through a ROLE we created - this role has EXEC rights to all our stored procedures. We have never yet given a user SELECT rights to any tables... So now we are thinking that we can create a VIEW - give a user access to that VIEW (through the ROLE they al...more >>

Hello, We have about 16 servers running with SQL Server 2005, almost all have same databases replicated for users in each location, so the problem is we want to have only one maintenance plan and been able to copy or update it on the other servers without having to do changes manually for eac...more >>

Hello, We have about 16 servers running with SQL Server 2005, almost all have same databases replicated for users in each location, so the problem is we want to have only one maintenance plan and been able to copy or update it on the other servers without having to do changes manually for eac...more >>

I'm attempting to create an assembly in SQL Server Management Studio express and I'm getting the following error message. Msg 6502, Level 16, State 7, Line 1 CREATE ASSEMBLY failed because it could not read from the physical file 'Iit457wks1.Telspan.Intra\c$\TriggerUpdate.dll': 50(The request is...more >>

Hello, Tricky question here. I work with sql server 2000. Berfore I got here there was no DBA. So everyone used the sa user for their applications. I need to know if it's possible to remove privileges from the sa user, so I can create a new user with "super administrator" privileges, ...more >>

I need to delete all the *.txt file in a specific folder modified date is older than 2 months,. How can I do this in a stored procedure?...more >>

I have SQL 2005, 64bit version installed with SP1. I am seeing the following errors in the Windows event log: Source: SideBySide Event ID: 59 Resolve Partial Assembly failed for Microsoft.VC80.CRT.mui. Reference error message: Access is denied. Source: SidebySide EventID: 59 Generate Ac...more >>

I am working on the sample Adventure Database that comes with SQL server 2005. The tables are group by the schema!?? i.e. company.employee company.sale etc. company is the schema and employee and sale are tables. I found this is pretty new to me. Can someone lead me to the right directi...more >>

I am trying to connect to a remote SQL Express server (using query analyzer) and I am not able to. If I run SQL Server Managemant Studio I can connect (using Windows Authentication). I have tried using the IP address of the server and just the server name but no luck. There is only one instan...more >>

I have a SQL Server database that has a very large database transaction log file (bf_log.ldf) that continures to grow. I would like to change the recovery model from full to simple and truncate the database transaction log file. What is syntax to truncate the database transaction log (bf...more >>

Is there a way to do a search inside a specific database for a specific field. My problem is I have a db with about 200 tables and I am not sure which one holds a specific field. Is there a way to find that field without going into every single table? ...more >>

Hi, I have SQL 2000 DB that I do not want to upgrade to 2005 however I want to install 2005 and start building new DB's. Can I remove 2000 and install 2005 and connect to the old 2000 db's using Management Studio? I do not want to have both installed. Thanks ...more >>

I have been assisgned the task of upgrading to sql 2005. I was given a dell poweredge 1850 and the sql standard edition 2005 w/ 5 cal disk. I have only used sql a little to make data changes in tables. My boss expects me to figure this out on my own which I like to do anyway. I remember he ment...more >>

I have been assisgned the task of upgrading to sql 2005. I was told there is a server and sql standard 2005 disk in the back room. I looked and found a dell poweredge 1850 and the sql standard edition 2005 w/ 5 cal disk. I have only used sql a little to make data changes in tables. My boss isnt...more >>

I have a SQL Server database that the database transaction log is growing very large. The database Recovery Model is set to full. If I change the recovery model from full to simple will the transaction log truncate when the database is backup daily? What are the best procedures to shri...more >>

Hi, I want to change the identity values of an identity column of a table that already has rows in it, such that, it begins at zero and goes up in even numbers - that is, like 0, 2, 4, 6, 8, etc.... instead of the usual 1, 2, 3, 4, etc.... The current values of the identity seed & identit...more >>

HI All, Can any one explain me the use of the DBCC command called dbcc dumptrigger Thanks and regards Praveen ...more >>

Hi just read an article on the internet that states "A quick way to resolve a blocking problem is to disconnect the connection blocking the rest of the users. All you have to do is ask your database administrator to execute the KILL statement. Obviously, this is not a permanent solution, and w...more >>

Hi folks, I'm using SQL Server 2005 SP1 and wants to know how to set to OFF the setting ANSI_NULLS. When I create or modify a SP, SQL Server 2005 proposes automatically the settings (global) SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON When I modify the SP cliccking on "Script store proce...more >>

Hi My Backup policy is to take transaction log backups every 30 minutes... what if my server crashes at 10 minutes before a Transaction log backup takes place... e.g. Full Backup 1:00 pm Transaction Log Backup - 1:30 pm Transaction Log Backup - 2:00 pm Transaction Log Backup - 2:30 pm ...more >>

Hi, In my SQL Server 2000, I have a table UserTable which has all users data in it. e.g., 0001 John 123456 0002 Mary 223456 0003 Tedy 333888 .... I also has other tables ValueTAble, PreciousTable. As the table names implys, the 2 tables are very important, and I need to know which u...more >>