How many violations are needing to be submitted at one time from the front-end? Or are you passing them to the database one-at-a-time? I am thinking table-valued parameters may be...

How large of an attachment are we talking? msdb.dbo.sp_send_dbmail can send query results as a csv attachment but there are limits on the size of the attachment it will send...

1. Create 3 Variables

- one of type Object that will contain the list of databases

- one of type Int to contain the database_id

- one of type String to contain the...

ErickTreeTops (2/10/2013)

---

I have VS2012 ultimate installed. In the "Installed products" under the VS2012 Help Menu it states i have SQL Server Data Tools 11.1. When I go to SQL 2012...

Brent Ozar and Paul Randal both have posted research and findings on the topic. Google or Bing are your friend there. I just pulled back a bunch of relevant results.

800MB is an awfully large XML document. Note that when represented in memory as an XMLDocument object it will occupy far more space that just the file on disk. How...

SSIS can page data to disk if there is memory pressure. In what format the data is written though, I have no idea. Nor do I know where it is...

Please do not cross-post. It fragments replies and wastes people's time.

Direct replies here:

http://www.sqlservercentral.com/Forums/FindPost1420715.aspx

Nice work. For keeping log backups around...it depends on how long you need to retain point-in-time recovery. I usually keep mine around for ~10 days, or whatever my log shipping...

They are Event Data columns, not Events. When you are defining the Trace make sure you capture the StartTime and EndTime columns on all Events you add to the Trace.

Read...

The information you have provided does not compute. Are you sure your login has access to that table?

What does this return?

SELECT *

FROM OPENDATASOURCE('SQLNCLI', 'Data Source=DESTSERVR\INSTANCE;Integrated Security=SSPI').TESTTBL.sys.tables

WHERE...

Who said anything about OPENQUERY? You do not need OPENDATASOURCE to work with a Linked Server.

lsalih (2/15/2013)

---

When I go to linked server, I can see the system catalogs. Below is how I created the the linked server:

EXEC sp_addlinkedserver

@server=N'Webdev',

...

See if this gets you there:

http://www.yourdba.com/?p=122

opc.three (2/15/2013)

---

Check that the Windows account you're using to log into the SQL Server with has a login and permissions to select from that table on the remote server. If...