What if...

Remove GO. It's a batch separator for SSMS, not a command.

You almost got it right:

declare @sqlcommand nvarchar (500)

declare CRS cursor

for

select command from #test

open CRS

FETCH NEXT FROM CRS INTO @sqlcommand

WHILE @@FETCH_STATUS = 0

begin

-- PRINT @sqlcommand

exec SP_EXECUTESQL @sqlcommand

...

That's a very common error :hehe:

Chitown (11/6/2015)

---

Is it possible to create a script which changes log file size to let's say 100MB for all DBs in all servers instead of running the above command by...

ben.brugman (10/30/2015)

---

Technically it would be possible using the index containing the F column and then using the Covering index table. (Fields A and B are present in the F index,...

You can try to pass a boolean parameter into the report when it's executed by a subscription and then handle it in the report by using "Visible" property of the...

Why do you even need a nested statement?

SELECT [ID_APD_Stips1], [Stip_Abv], VRSNavID, T.STIP_WasaMatter +'You' as Stip_WasaMatter_you

FROM [RegulatoryDB].[dbo].[APD_Stips1]

INNER JOIN vsrNavigatorSHLBHL ON NV_RegToNavLink(???).NAV_Well_ID = vsrNavigatorSHLBHL.WELL_ID

CROSS APPLY (SELECT STIP_WasaMatter = [Stip_Name]+'WazaMatter') T

How many records...

Replication?

toniothomas (10/2/2015)

---

Check if the query posted at this link works. Seems to get me what I want with respect to an index creation date

http://www.sqlpanda.com/2013/10/how-to-check-index-creation-date.html

SELECT object_name(i.object_id) as TableName, i.object_id, i.name, i.type_desc,o.create_date,o.type,i.is_disabled

FROM...

You don't have the same issue here....

coolchaitu (8/12/2015)

---

Our environment is very laid back and not at all critical, hardly we get transactions. So, no problem if i take 3 or more weeks of time to do...

coolchaitu (7/27/2015)

---

Thanks for replying. There is also this "ACCESS_METHODS_SCAN_RANGE_GENERATOR" from the screenshot.Could you please let me know how to deal with these kind of issues and how to resolve these...

It's really hard to tell for sure why...

coolchaitu (7/26/2015)

---

Hi Alex,

Here is the type of column PickUpTime:

PickUpTime(udt_Date(datetime),not null)

udt_Date is user defined type and here is its definition:

CREATE TYPE [dbo].[udt_Date] FROM [datetime] NOT NULL

tblBidMaster table size is 84.5 MB...