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 >>

Hi everybody! I have the following problem: I have many tables in my database and for some columns it happens that when I try to update them, I get the error message, that the update doesn't work properly, because of "Key column information insufficient or incorrect". This happens only for a f...more >>

I understand that the 64 environment allows more addressable memory. Are there any additional performance benefits other than possibly those gained by increased memory addressability? Assuming the same database running on a 32 bit environment and a 64 bit environment and applications hitting b...more >>

I am going to do a sizing of memory for a server SQL Server. I am finding the calculations of memory for each user connected to the SQL Server for carry out this sizing. I stayed grateful by any help. Thanks! Jonildo ...more >>

Hi guys, i reading the MOC 2733A for SQL2005 and found the "sys.fn_indexinfo" function in a module 5 but when i run a sys.fn_indexinfo how indicated a error showed Seems that not exist ... it's possible ? It was replaced ? If so how i can view a index defrag status ? Thanks in advanc...more >>

I have 300 records in one table. I want to select that in 3 times, each time 100 rows. Anyone have some idea how to do that?? So, I would have 3 queries and each query would get 100 records. If anyone can help.... Thanks!! ...more >>

I am trying to export and XML Explicit query using bcp and occasionally an element descriptor is trunctated on larger files. Any suggestions on how to avoid this problem. Is it possible to force a linefeed after each element in the sql output? TIA Rob ...more >>

Hi, I have a real "noob" question, and I'd appreciate it if someone could help me out. Below is the general specs of the server I am running. Product: Microsoft SQL Server Standard Edition Operating System: Microsoft Windows NT 5.2 (3790) Platform: NT INTEL X86 Version: 9.00.2047.00 Memo...more >>

When I look at the properties of the SQL Server and go to the Security Tab, the startup service account area is greyed out. Why can I not see if it's using a local system account or a domain account? (Windows 2003 sp1 server running SQL2000 sp4.) Thanks ...more >>

Will creating an index while a database is in use block user access? Thanks. ...more >>

What if we want to take complete backup of production database except values in a particular column of a table. Suppose if we don't want to reveal social Security number of employees . Can we take a backup to send the offshore team with no data in SSN column of employee table. ...more >>

I am collecting objectids in a SQL Server 2000 Profiler trace. I am capturing the events: Stpred Procedures: RPC Completed and SP Completed and TSQL: SQL StmtCompleted. When I try to identify the objects being called either with object_name(id) or marching on sysobjects I get many objects ...more >>

I was recently given a db script that was generated from an Oracle db. I need to put the db in my SQL server using this script. Is there a tool that will convert the script for me, or do I have to do it all by hand? It will take me days to do it by hand. Connecting to the Oracle db is no...more >>

I register the server using SQL Server Enterprise Manager. Next day, all my settings are gone. So I need to register server everyday. ...more >>

What are the differences between Remote Server and Linked Server anyone have a good reference page ? ...more >>

Hi, I have a database user with read-only permissions in the database. The user would like to be able to display a list of stored procedures in the database. I would like to grant this user the permission to do this, but without granting permission to *change* the sp's in any way. Is ther...more >>

I need a SQL query that could give me a processor count and mhz info from query analyzer. Please help Thanks, John...more >>

Howdy Everyone, In SQL 2000, I used SQL Enterprise Mgr --> Task --> Transfer Logins Task --> Source Tab (select sourcce sql server name--> Destination Tab (select destinate sql server name) --> Logins (select database name). What about in SQL 2005? I am new at SQL 2005 but love to learn n...more >>

Hi All, I need to take a backup of a database without taking backup of few tables. So if i have a database Name production with a number of tables including salary table. All I want is to take the backup of complete database without taking backup of Salary table. Isthee any way to do so? ...more >>

I am importing a table in my db from a txt file having data fields separated by ' ; ' After the import, I want to make one of the field as numeric which is imported as varchar. The problem that I face converting is the data that I get can be negetive. During import negetive value comes as varch...more >>

how do I bring files from mssql2000 to mssql2005? A BAK from 2000 doesnt seem to work as it did in mssql97 & 2000 thanks, Raul Rego NJPIES ...more >>