Use this tag for questions specific to the 2008 R2 version of Microsoft's SQL Server.
I have trouble figuring out if the SP1 is already installed. I don't think I could check it from the …
sql-server-express sql-server-2008-r2I have a table called MyTable on which I have defined a trigger, like so: CREATE TRIGGER dbo.trg_Ins_…
tsql triggers sql-server-2008-r2 linked-serverI dont have users in sysadmin except [sa] user unfortunately, I logged in as [sa] user and disabled it then …
sql sql-server tsql sql-server-2008-r2 accountI am using Sql Server 2008. I have a Trigger which updates my two other tables. I have read the Stack …
sql triggers sql-server-2008-r2 event-triggersI am using Microsoft SQL Server Management Studio. I have two databases one is the system database, which has the …
sql sql-server-2008-r2Hope this doesn't seem too simple. I've looked this up but I'm not so good at SQL user defined functions …
sql function sql-server-2008-r2 boolean where-clauseI have been experiencing a strange issue for last few weeks. On my two different servers the sql server Agent …
sql-server sql-server-2008-r2 sql-agentI am trying to pass a variable into a SELECT statement in OPENROWSET but I keep getting an error DECLARE @…
sql variables sql-server-2008-r2 openrowsetI'm trying to use this in Microsoft SQL Server 2008 R2: SET @SomeVar = @SomeOtherVar + IIF(@SomeBool, 'value when true', 'value when …
sql sql-server-2008 tsql sql-server-2005 sql-server-2008-r2What is the max size of a file that I can insert using varbinary(max) in SQL Server 2008 R2? I …
sql-server sql-server-2008 sql-server-2008-r2 varbinary varbinarymax