scrubbing data is really nothing more than an update statement, but you have to come up with a pattern for your updates.

in my case, I've got a suite of tables...

preview mode creates a cache file, and does not always call the server to get the data; if you look, you should see a rdl.data file, i believe.

delete that file,...

i looked at sp_applock, and it would not give you any granularity at the object level.

I'm not sure if the OP is just second guessing SQL locking, and is...

I believe that only Standard and Enterprise have paths for in-place upgrades;

all other versions, like express, require an uninstall and re-install, i think.

so you'll want to either do a side-by-side...

answering my own question, by converting ms_ticks to seconds, i think i see what i was after:

--ServerRestartTimeServiceRestartTimeServiceUpTimeInDays

2015-08-22 21:46:51.9802016-03-29 08:34:07.89087

-- select

DATEADD(second, -1 * ( ms_ticks / 1000),getdate()) as ServerRestartTime,

...

you are looking for a data driven subscription, which is an enterprise feature; are you using SQL enterprise or standard?

the subscription can use a table or view to feed the...

i believe the GUI will DEFAULT to use Local Users to the server, and you explicitly need to select domain. annoying, for sure.

so if i search for mydomain\lowell, it...

here's a snippet i use for auditing...

reading it again, since you want to hav eby month, the date logic needs to be int he group by also:

Select

br.Branchno,

DATEADD(mm, DATEDIFF(mm,0,vw.viewdate), 0) As MonthViewed,

...

here's my best guess.

Select

br.Branchno,

DATEADD(mm, DATEDIFF(mm,0,vw.viewdate), 0) As MonthViewed,

Count(*) As TotalViews

FROM Branch

INNER JOIN Registration rg ON br.Branchno = rg.Branchno

INNER JOIN Client cl ON rg.Clientno...

Welsh Corgi (6/21/2016)

---

The following list the Extended Properties for each column in a table:

SELECT * FROM ::fn_listExtendedProperty

(DEFAULT,'schema', 'dbo', 'table', 'Event', 'column',DEFAULT)

How do you list the...

dastagiri16 (6/20/2016)

---

I have configured peer to peer replication for two nodes.

i have initialised the subscription from backup.

Both the nodes are sync after completion of the setup but when i inserting...

here's some of the things i could think of off the top of my head:

1. Is the query itself SARG-able?( search arguments in WHERE statements will use an index?)

look for...

without your table definition so we know what you are auditing, we cannot help much, but what you can do is simply insert into your audit table, from the sys.tables...

so, a string that happens to contain numbers then, since you included a space?

i...