Thank you.

Runnning sp_table_privileges as a sys admin returned results similar to what Gail posted. Which doesn't show me table permissions, just who can grant permissions??? (right?)

I'm not sure what...

GilaMonster (8/23/2016)

---

If they're getting denied access to just one table, then there's a object-level permission set on that table. Check the DMVs for the details, you can then use REVOKE...

Thanks, John

Thank you, Scott.

So I take the same code and try to create a stored procedure by adding this:

IF OBJECT_ID('usp_DataLoadTime', 'P') IS NOT NULL

DROP PROC usp_DataLoadTime

GO

CREATE PROC usp_DataLoadTime

AS

BEGIN

... <code from above....>

END

...and...

Steve Jones - SSC Editor (10/15/2014)

---

If that's the case, trigger.

Simple. Make it row based, and you can use Merge, but I'd just do.

create trigger

update LastTime set time = i.time

from...

Steve Jones - SSC Editor (10/14/2014)

---

OK, I'm still slightly confused, but I think you mean you have a source where you have everything, all records. However you only want the...

Thank you, Steve

I would like to save a record...

Tavis Reddick (8/19/2014)

---

I am not sure about the report, but the SQL Server Management Studio issue seems to be that you are saving the results (possibly as text or CSV),...

Going from bad to worse...

Whether I use the query directly in a report, or put the query in a stored procedure, this is the result:

<?xml version="1.0" encoding="utf-8"?><Report xsi:schemaLocation="SQLTestServerTest2

Allow me to illustrate

USE MyTempDB

GO

IF OBJECT_ID('MyTempDB..SomeTable1','U') IS NOT NULL

DROP TABLE SomeTable1;

CREATE TABLE SomeTable1

(

...

Thanks, Jack

I very much appreciate the time that you took to clarify this for me. We have TFS, but it's currently only used for c# projects.

Time to learn...

If you can possibly describe how you get the file to output, I would greatly appreciate it.

I have a query where I can get the XML that I need, but...

Please post your solution!

Thanks...

Apparently, the Stairway to SQL Server Indexes uses the Adventureworks 2005 database.

I have tried (without success) to install the Adventureworks 2005 database on SQL Server 2012.

Perhaps an updated Stairway, based...

The best thing to do is set up Reporting Services and learn the basics of that. It is extremely easy to set up and you can scale it out...