Log_reuse_wait_desc = ACTIVE_TRANSACTION
Jan 27, 2020 · I've a SQL Server 2016 - 130.4411 Standard Edition. I've a database log that keeps filling up (log is 250GB), select log_reuse_wait_desc from sys.databases says that the …
How to pass a variable for a SQL query in OLEDB source?
Feb 23, 2015 · When trying to retrieve the data from source using the variable (i.e. SQL Query with variable), I am not able to add the query as the SQL statement box is disabled. How to …
Execute dynamic query stored as varchar in a different table.
Jan 6, 2014 · But it doesnt seem to work because it is taking the @query as varchar and not an actual t-sql command.I want to keep the query dynamic as each row in my table has a different …
Subquery for measure in MDX - social.msdn.microsoft.com
Nov 29, 2009 · But I need to create a query which returns Costs per person, so I need a subquery to calculate person count, such this sql query: SELECT COUNT …
Declare a table name in Store Procedure
Jan 12, 2012 · You are mimicking the old 1950's mag tape file systems in SQL! The operator would hang a tape and type in the tape label at that time or the system would generate it for you.
DataAdapter always returns 0 or empty rows
Dec 20, 2010 · I just like to ask if anybody has experienced getting empty rows from SQL data adapter? I'm using SQL Server 2005. Problem is when the sql is run on Query Analyzer it …
Convert VarBinary type to Any Type - social.msdn.microsoft.com
Aug 15, 2012 · Question 0 Sign in to vote Hi In my database there in two columns Type contains types in string like "system.int32","Bool","String" etc Value contains corrosponding to type …
Create Combobox with sql query filter from another …
Jun 16, 2014 · I'm placing a combobox to select an item from a sql query. From that Item selected there is another query that need to be achieve to see only item related and need to show into …
Query Rewrite - How to Avoid Multiple Left Outer Join
Apr 9, 2014 · We have a database, using Entity–attribute–value model. So, we are using automatic SQL Query generations, which generates a lot of Left Outer Join. Is there a better …
Cannot process the object "exec DBNAME.dbo.usp_TEST". The OLE …
Aug 23, 2011 · I have created a sql clr based stored procedure in a SQL Server 2005 database that accepts SQL query in a parameter and returns dynamic resultset based on the query.