Search results for query: *

Guys, Is it possible to disable or prevent Trusted Connection logins to Sql Server Express 2005 installed on a laptop for non-admin accounts using DDL triggers? Also, could I restrict any login attempts, either Windows Authentication or Sql Server authentication, to only admin and webserver...

Hi all, I am tasked with a general problem to come up with scenarios and possible preventive measures to take for the database of our product. Our product could be installed in a Server environment managed by an IT department or on a laptops for field inspectors. So I need to come up with ways...

Guys, Since I've not done this before I am not sure if the way I am planning to do this is okay or is there a better way. Like using Windows Installer or Install Shield or Windows Installer XML (WiX) toolset. Any help would be great, as I have no clue. We have a product and we ship new version...

The default trace file that is located in the following location: ~\Program Files\Microsoft SQL Server\MSSQL\LOG\log_1.trc ~\Program Files\Microsoft SQL Server\MSSQL\LOG\log_2.trc ~\Program Files\Microsoft SQL Server\MSSQL\LOG\log_3.trc .... .... .... How do I configure to increase...

Thanks for the response. I've tried "READPAST" and "NOLOCK" on some select statements and it seems to have prevented some deadlocks. But I still have a lot of deadlocks happenning with other select statements ( with update). I am not sure if I could just keep adding this LOCK-hints to all the...

We have a DB that is heavly hit. Recently, we started to notice deadlocks on this machine. Now its up to one deadlock every 5 minutes. For the most part, deadlock occurs between a select query (either inside a Stored Proc or just straight select query) and an update statement. Some DB info...

Thanks for the extra explanation... Thats exactly what I thought.. Have one process that talks to all the servers, and stores in one database [DBA-db]. For now, I am working on a VB.Net EXE process to run on a schedule. Let me know, if you want to share or exchange any ideas, _ub

I am not sure I understand what you say. But I'll try to make it work for us. thanks, _ub

Hi, Is it possible to restrict users that use Enterprise Manager from deleting maintenance plans? Could anyone please point me to a good URL that talks about this. thanks a lot, _ub

Thanks a lot Mutley1. I have a procedure close to your script. But for this to work, I'd have to run this procedure from each instance and populate records into a "DBA"-database created in all the 80 instances, which is not an easy task. Ideally, I'd like to have one process that does it all...

Hi All, I searched previous posts, but couldn't find solution to my current scenario. We have about 80 SQL Server Instances on about 50 Boxes. Equal percentages of 2000 & 2005. Total of about 490 DBs I need: 1: A way to identify the pattern of size increase [both TRN log and Data file] in...

that was simple. !!how could I not think of that!! Thanks everyone. _ub

Hi everyone, I have a table: T1 Col1 Col2 NULL 1 son 1 sun 3 NULL 4 su 5 And a stored Procedure with a query that queries that above table. ----- Stored Proc ---- Create procedure (@param1, @param2) ... query ... GO ---- End of Stored Proc ---- I need to write a query, as...

You are the nicest. thanks a lot again, _UB

Is there a way to delete this thread? _UB

thanks. I thought I knew 'DBCC DBREINDEX' command very well. But you never know. I'll try it and see how it goes. thanks again, _UB

thanks for quick resoponse Isn't reindexing clustered index like re-creating table [drop and create with new options]. or is there some option like alter index .... REBUILD like in Sql Server 2005

Hi there, [not sure if this is the right category, but] I have a sql server 2000 database with about 5 million records. The table has about 30 columns and 10 indexes. Clustered index on PK Non-Clustered indexes on other important columns DBCC SHOWCONTIG scanning 'MyTable1' table... Table...

Hi there, I have a sql server 2000 database with about 5 million records. The table has about 30 columns and 10 indexes. Clustered index on PK Non-Clustered indexes on other important columns DBCC SHOWCONTIG scanning 'MyTable1' table... Table: 'MyTable1' (699149536); index ID: 1, database...

thanks SQLSister. The function that I have does exactly that. thanks everyone, _ub