Viewing 15 posts - 8,176 through 8,190 (of 13,469 total)
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...
February 3, 2011 at 7:44 am
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...
February 3, 2011 at 6:22 am
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,...
February 2, 2011 at 2:12 pm
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...
February 2, 2011 at 1:41 pm
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,...
February 2, 2011 at 12:28 pm
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...
February 2, 2011 at 12:20 pm
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...
February 2, 2011 at 11:56 am
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...
February 2, 2011 at 6:20 am
rakkpra (2/1/2011)
We have a History table but like Emp is my current table and EmpHistory is our History table .
Emp Table only have current table and EmpHistory...
February 1, 2011 at 1:28 pm
do you have a table that does an audit or history for when someone changes their title?
so if i got promoted to "Developer 3" , is that stored in a...
February 1, 2011 at 1:00 pm
not sure buddy; from what you described, the first two queries (i thought) would return something; can you show us the actual queries you tested with?
what is the datatype of...
February 1, 2011 at 10:15 am
ouch; looks like a varchar column is being used to hold dates, instead of a datetime datatype; i've inherited a few of those situations myself.
one of the first things you...
February 1, 2011 at 9:18 am
SELECT @CountOUT = COUNT(*) FROM [' + @REMSServer + '].rems.dbo.[Order
the above string is exactly 70 characters; if @SQLString is too small, it'd truncate and give that error message. what...
January 31, 2011 at 2:25 pm
I'm asking you to think outside of the box for a moment. you seem to be locked into one method, and i'm suggesting an alternative.
it looks to me like you...
January 31, 2011 at 11:09 am
if it fails on only one procedure, i'd just fix it manually and be done.
Are you sure this is something that must run in all situations, or is this just...
January 31, 2011 at 9:56 am
Viewing 15 posts - 8,176 through 8,190 (of 13,469 total)