Brandie iIm pretty sure it works for 2000/2005 instances, but i don't have a non-default 2008 or R2 to confirm that snippet still works yet.

thanks for the kudos!

are for the gory details, you can run this query to detect the ports for all your instances, or go to this property panel to see and change the...

The usual answer: it depends on the view, and the data that is in it. when it's a simple join of multiple tables, you can often update the view directly.

if...

the stored procedure you are calling...does it references the table that the trigger is on?

the trigger has got a lock on any rows that are being inserted/updated/deleted...so if the stored...

as bitbucket stated, you need to re-evaluate the requirements...noone will ever need to actually view that many transactions without filtering it for relevancy, so don't go down that rabbit hole....

take...

there's an extra option for raiserror so you can get immediate feedback; with nowait, and that shows up immediately in SSMS:

here's an example:

--print error immediately in batch

declare @i int,

...

Zeal-DBA (2/3/2011)

---

no i am saying data size is 4 gb but mdf has initial size 191 GB. and m reducing it from the same window wat shown in screenshot...

you might want to explain what the issue is that you are trying to resolve. even if you change the "Initial size" of the db, it's not going to affect...

well, you'd have to have the list of logins first...

lets assume you want to drop all logins on a given server, and not just 100 specific ones? is it 100...

no, i mean if you look at the definition of the table in SQL Server Manangement Studio, is there a trigger on it at all? that is independent of Labview,...

is there a trigger on the table that Labview is inserting into? if the trigger is raising an error, that would explain the missing data...if there is a trigger, maybe...

great job on your first post providing lots of details..thank you!

This is fairly straight forward; the IIF is really equivalent to a CASE statement like this; you provided everything else,...

yes that is correct; you cannot resotre 2008 on a 2005.

you can restore a backup from a lower version to a higher version, but not downward to lower versions;

you'll want...

yeah a quick google shows lots of different programs use rep files, so there is no standard...it depends on what program exported it; i doubt you are importing files form...

the value looks like the # of seconds, as Ian said; so you could add the seconds to the date component to get the read date and time, right?

and pull...