GRANT SELECT ON dbo.SampleTable(Column1) TO User1

If you have SQL Server Enterprise Edition I would pick Peer-to-Peer.

However, have you been successful in creating basic Transactional Replication when data flow only from publisher to subscribers? As...

With only SQL Server 2008 R2 Express Edition you can't really implement any of the H/A scenarios. See Compare Edition Features article for H/A scenarios that EEdition can be...

After you will add two articles, you can alway recreate subscription with 'no snapshot initialization'.

To get your publisher back online, you will have to

1. drop existing subscription

2. restore subscriber database to the publisher server with don't keep replication settings option

3. setup publication ...

Answering your question about training materials

SQL Server 2005

Kimberly Tripp record the whole series 'MSDN Webcast: A Primer to Proper SQL Server Development ' for SQL Sever 2005 developers, this is...

I've checked your website and you are not offerint anything for free as far as I can see.

I'm aware of at least two projects where NHibernate has been used successfully for a while now (2 years or more). Having a deep understanding of NHib internals is crucial,...

If you will change the structure of the tables (e.g. by replacing GUIDs with Int's) you will break Microsoft implementation of Membership, Role providers (stored procedures, permissions model, .NET implementation...

Hi,

SSIS related questions should be posted on this forum (SQL Server 2005 Integration Services, http://www.sqlservercentral.com/Forums/Forum148-1.aspx).

1) If you are running SSIS package from SQL Agent you could configure JobStep to run...

Or

DECLARE @result VARCHAR(50)

SET @result = (SELECT TOP 1 Student FROM #Table WHERE StudentID = 1)

SELECT ISNULL( @result, 'NO STUDENT EXISTS')

It's important to use SET operator (not SELECT), so that @result...

SQL Server as a product has versions, you can view it by calling following functions.

SELECT @@VERSION

Could you be more specific to what version you are referring to, as schemas in...

Hi,

SSIS related questions should be posted on this forum (SQL Server 2005 Integration Serviceshttp://www.sqlservercentral.com/Forums/Forum148-1.aspx)

Anyway, I guess that by Generic Windows Account you mean local account which is not a domain...

If 'Message' column has XML data type than you can construct XPath query to retrieve the error message.

Check following article on MSDN where you can find all kinds of queries...

CLR stored procedure is not encrypted, it's just the way it's displayed in the SSMS object tree. You can't dump code for this particular StoredProc as it's implementation is embedded...