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...

SELECT 12345[highlight="#ffff11"]00000[/highlight] + ID, so as long as your Id is less than 99999, it fits your criteria.

sunil.mvs (6/15/2016)

---

we have started new team of datawarehouse in our company.

Team started working on SQL Server 2014 and TFS .

They developed packages using project deployment...

SQLPain (6/15/2016)

---

On the report a field is populated from a column X whose datatype is int. the problem is we don't if that number is a percentage or a amount,...

Lowell (6/15/2016)

---

my understanding is similar to George's:

services consume licenses, but tools and connectivity do not. that's reinforced by the same tools being part of a separate downloadable install package.

only when...

my understanding is similar to George's:

services consume licenses, but tools and connectivity do not. that's reinforced by the same tools being part of a separate downloadable install package.

only when you...