I am porting an application from MSMQ to Service Broker. The nice thing about MSMQ is you can call a function that blocks until something comes into the queue. So the application receives the message instantly. How do you achieve this in service broker? When I do a RECEIVE AS MESSAGE FROM ...more >>

Select most recent date, single ID from a list a ID numbers (with duplicates) and dates? Suppose I had a table with this data: ID DateOf 499 2004-03-05 499 2006-11-13 500 2003-09-09 1529 2005-01-10 1529 2004-03-25 1529 2004-08-31 1529 2006-10-27 1742...more >>

Hi How fast (row/sec) is it that sql can copy data straight from one server to another server. I am using SELECT INTO? how fast in an insert for the above case? How/where do I find these sort of info? Thanks ...more >>

I am trying to create my first udf based on a stored procedure. We cannot use the procedure because we need to be able to use it in a select statement and the product that is the front end requires it to appear like a column. My problem is that the UDF returns a row for each record in the curs...more >>

Should I have to indexes on single column or a composite index for this query Select x FROM TABLE1 A inner join TABLE 2 B ON A.ID = B.ID AND A.myDate BETWEEN (B.mydate and GETDATE()) 2nd. Do I need to index on both table or just one table (B) is goo...more >>

Hello, I would like to give a customer management capability over their own database using SQL client tools. .. I create a DBO user who has access to only one database. When they go to the database, they can see all the other DB's on the server, but can't get to them (This is good). But o...more >>

Hi guys, Is it possible to assign a TimeZone to a SQL Server database? We have different databases for each of our clients. And clients are in different Time zones. I want the "GetDate()" funtion to return time according to the timezone setting of that particular database. Is it possibl...more >>

Is there anyway to call an Assembly from SQL Server 2005 without actually importing the assembly inside the sql server? Any command can accomplish? Thanks in advance ...more >>

Is there a way in SP for me to force the order of execution of sql statements. I have something like this. delete table1 where..... update table1 set .... where .... I want to place something like the *go command that is not available in a sp. How does one go about this? 2 sp's? ...more >>

CLR Shared Memory, C# DLL load How to share memory between CLR calls to the same C# dll? Is there some way to know in the C# dll when the dll is loaded? Is the dll reloaded each tiem a method is called from SQL Server or is the DLL loaded once when the C# dll is added to sql server with CREATE...more >>

I don't understand how to keep a perf mon log running 24/7/365 on a Win 2003 box (w/ SS 2005 SP4). The problem is that we have machines that sometimes get rebooted - either by a surprise shutdown or by another dba who forgets to tell me - and the perf mon doesn't get restarted. I've got an O...more >>

Hello Everybody, I hava a description column with nvarchar(90) datatype is a table. I have around 300,000 rows into table. Now if I want to know how many rows have unicode characters into column description, How can I find it. Out of 300K rows only 5-10 rows will have unicode characters into...more >>

Our application can have multiple companies, and each company is an SQL database. When the user goes it, it displays a list of all companies this login can get into. During that process, it is connecting to each database. So when the user selects a database and that is the only one they are in, ...more >>

Trying to get Native XML Web Services setup in our test enviroment, and I've hit a problem. When the HTTP EndPoint is set to use Integrated Authentication, I can browse to the endpoint (using IE7 from a seperate PC) and get the WSDL back, but when I switch the EndPoint to use KERBEROS authent...more >>

I've got a 2000 SP4, 8-way server that from 3:00 pm to 4:00 pm has pretty low cpu usage: 0-10% but with a ratio of %Priv/%Proc of 20+% for, say, 40 out of the 60 minutes. That's nothing to worry about with the low cpu utilization, right? Or is this a sign of some other problem possibly? ...more >>

Hi, I have a stored proc that I would like to return a value to Windows OS. I thought of using Raiserror to set a code (I want to return an integer value) so that I could pick up the value in errorlevel. But using option -b, I can only get errorlevel to be equal to 0 or 1. Is there a way...more >>

I have a situation where a stored procedure is populating cursor from a view on the same server. The view, however, references tables on another SQL server. The SP code which calles the view: DECLARE curBaseFile CURSOR FOR SELECT BaseFileNumber, Percentage, Round(@Amount * Percentage, ...more >>

Hi, I am converting an MS Access query to SQL Server. SQL Server does not like the following code. In particular, the error refers to the \ or division symbol. It actually says near the \. Can someone help me with this? Thanks, ((([quantity]\24)*24)*([salesprice]-[salesprice]*0.1))+((...more >>

Tempdb is set at 1000 MB. Once in a while it will grow, recently at 12,580 MB. Is there a way to set up a SQL Server Agent Alert to tell me when it grows past 1000 MB, what query, and who is responsible? This occurrence happens maybe once a month or every two months about. I do not want...more >>

Hi I am using dynamic Sql Statment, where i provide Database name. If @lDbName = 'Parent' Begin Set @lSql = 'Select ColA, ColB From Tbl1 Inner Join Tbl2 On Tbl1.MatchCol1 = Tbl2.MatchCol1 And Tbl1.MatchCol2 = Tbl2.MatchCol2' End Else Begin Set @lSql = 'Select ColA, ColB From Tbl1 Inner ...more >>

Hi, I have an indentity column in some table and i use while loop to move record by record within a table by incrementing 1 in the identify column. Is using of while loop is equalient with using of cursor, in the terms of performance? Are there any other possibilities to avoid this thing? ...more >>

Hi I have sql 2000 enterprise with four processors with hyperhtreading enabled. I had a query that did not complete just showed lots of processor activity, once I changed the max degree of parallelism to 4 and kept the hyperthreading on --the query completes. With this setting on is it just...more >>

Dear all, Is tehre a way from SQL 2005 to get from a table the list of records which has changed after an Update, Insert, or delete and then create a new view out of this ?? thnaks for help regard serge...more >>

Hi, I have two tables: Table One ID|Data 1|Foo 2|Bar 3|Fee Table Two ID|Data 1|Apple 1|Banana 1|Cherry 2|Apple 2|Banana 2|Pear 3|Kiwi 3|Peach I would like to return a single row for each row in table one with all the items for table 2 which have the same ID: 1|Foo|Ap...more >>

Hi, I have three stored proc returning results (two fields) like : SP_1: A 1 B 2 C 3 SP_2: A 4 C 5 SP_3: A 6 D 7 I need to obtain four fields like this with another stored proc: A 1 4 6 B 2 C 3 5 D 7 Is there a way ?! Thanks. ...more >>

Our developers have added an extended property to a database, which they need to check in code during certain operations. Like so. Set @myvariable = select [value] FROM [sys].[fn_listextendedproperty] (default, default, default, default, default, default, default) I can not get the perm...more >>

Hello all, First after 20 hours of looking at this I am a little brain dead so here goes. I have 3 tables in a join to pull data, the second table is only to get information from the third table. That's the scenario. I need a case statement or something in there to produce the following 1. rec...more >>