A stored procedure returning a boolean value indicating wheter a specified value exists in a table. A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout ...
Finding Inactive SQL Server Databases Phil Factor demonstrates how to identify objects in a database that are not being used. The technique uses Extended Events to detect acquisition of Intent locks, and so determine which databases are active or apparently 'dormant', and then drills down to inve...
Finding SQL Scripts that populate table Anna40Reputation points Apr 29, 2023, 2:52 AM I've inherited tables and am being asked what parameters are being used in populating the tables. I've found the script that creates the table, but where do I look to find the procedure(s) that are ...
When using Visual Studio 2022 Find And Replace - Find in Files - it’s not finding the text I’m searching for, which I know is in some file. Until recently, only Visual Studio restart helped. Luckily, recently I discovered that this StackOverflow answer helps: https://stackoverf...
Call Stored Procedure into report builder Calling a report from T-SQL can grow property is not working in ssrs 2008 R2 Can I autosize my TextBox in SSRS? Can I move the legend outside of the Chart Area so that it can be "shared" between multiple charts using the same legend criteria...
However, at the time I was working on a number of scripts that query information from the plan cache in SQL Server 2005 and 2008 for a presentation I had in mind but never got around to actually doing. I mentioned this in the comments on the blog post and yesterday I was contacted by...
This simply means SQL Server will let you compile a stored procedure that refers to an object that doesn’t yet exist. You can read more about this here: https://msdn.microsoft.com/en-us/library/ms190686(v=sql.105).aspx In this situation, missing objects – and errors – may not be...
By default, SET NOCOUNT is set to OFF, at the SQL Server instance level, meaning that DONE_IN_PROC messages will be sent to the client for each statement in a stored procedure. When using the utilities provided with Microsoft SQL Server to execute queries, the message ...
You can create targeted searches with either theQuery Builder Formor Expanded Form. To customize the query string directly, you must use theQuery Builder Formas shown in this procedure. To build a targeted search available through the Quick Search field: ...
My aim in SQL Server was to accomplish the following task: select r.reagentlotid, r.reagentlotdesc, r.u_retestdt from reagentlot r where u_retestdt = DATEADD(DD,60,GETDATE()); Unfortunately, the above query was unsuccessful in returning any rows. Is there anyone who could assist me ...