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

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

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

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

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

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

Hi there, I have a webpage that calls a storedProcedure with @temp parameter ex: @temp = '1,2,3,4' --********** START PROCEDURE ************************ create proc usp_tt (@temp as varchar(12)) select * from t1 inner join t2 on t1.ID = t2.ID and t2.col in (Case...

Hi everyone, I started AJAX... as with everything, I am stuck in the starting troubles.. I read the tutorials at w3schools.... got the code for server side and client side scripts. But for some reason the IIS I have doesn't communicate with the browser in XML objects. [The code is exactly...

Hi there, I got some help from FAQ's, but now I am stuck at with a different problem.... Any help is greatly appreciated. Design: An ASP page with 4 multi-select List boxes, populated from a database. User selection [OnClick event] in one list-box, dynamically updates the list boxes on the...

Hi there, I am looking for an example on how to implement this: I have an ASP page with 4 multi-select list boxes. Only the first one is populated with some options. When user selects one/many option(s) from the first box, second box is dynamically populated, then the next... Is there a way...

Hi everyone, Pardon me if this question is in the wrong forum. We have a few IIS webserver that we want to open to the Internet. What is the best method? Case1: Have a routing server that takes all the requests [that only listens on port 80, 443] and redirects depending on the URL. ex...

Hi Very silly question.... but I can't seem to get it to working. It works for other examples, but just not for the one I want. Say, three variables: $file_name1 = "test.txt.pgp"; $file_name2 = "test.txt"; $file_name3 = "test"; I want to timestamp all three files, to look like: $file_name1...

Hi there, searched faq's and google, but couldn't find a complete solution. so here I post my question. any ideas are appreciated. I need some way to run a OS command and get 1: exit status 2: STDOUT 3: STDERR in three different variables. I use open3 to run a command: open3(gensym...