Viewing 15 posts - 4,351 through 4,365 (of 13,464 total)
SQL server must be installed on the same drive as the %SystemDrive% variable points to; there's no getting around that, but the binaries themselves don't take up nearly as much...
November 21, 2012 at 5:38 am
Bruce I've got both 2008 and 20012 installed; although the formatting/font is different for the tooltip on mouseover, i get the same information...
if you create a NEW table, that table...
November 20, 2012 at 12:58 pm
i see that if any of these four fields are null, the value inserted would be null:
INSERTED.PO_Number + INSERTED.AppUser + INSERTED.SoftwareShortName + INSERTED.HeatTicketNumber,
also , depending on the datatypes, if any...
November 20, 2012 at 12:14 pm
David the Import Wizard in SSMS is probably the fastest solution.
A full blown SSIS package, bcp /bulk insert with a format file, or the Import Wizard(which is SSIS Lite, really)...
November 20, 2012 at 10:04 am
I've got an example of this in my snippets; I've added a last example at the end, which returns just what i thought you asked for: only the words...
November 20, 2012 at 9:53 am
Concurring with Gazareth here; if the logins need to be migrated, you need to use sp_help_revlogin , which will maintain the password in an encrypted binary string so it can...
November 20, 2012 at 9:02 am
based on the other thread for the same issue the problem is SOME of his data is YYYYMMDD as a decimal, like 20121225, but some of his data is not...
November 20, 2012 at 7:54 am
tonyarp05 61903 (11/19/2012)
November 20, 2012 at 5:44 am
sapen (11/19/2012)
No this is not a special table. It has data in there luckily no value less than 50 for the column percent called so far.
in that case, you need...
November 19, 2012 at 5:21 pm
it will pass your current credentials,which i assume are your windows credentials;
if you hit it as sa, you'd get the typical error for invalid user.
November 19, 2012 at 5:15 pm
swarup.malli (11/19/2012)
I was trying to create a view for all the tables.
Could you demostrate how to implement this commoand inside a DDL statement for creating...
November 19, 2012 at 3:34 pm
man, if at all possible, change your columns to true datetimes immediately.
Like Sean said, one of a billion plus reasons to use the right datetime data type is headaches like...
November 19, 2012 at 3:21 pm
ok, is this a special table where there is one and only one row in the table?
the reason i ask is the variable population like this:
select @cnt = percentcalled
from dbo.[StatLog]
there's...
November 19, 2012 at 3:05 pm
yogi123 (11/19/2012)
Lowell (11/19/2012)
yeah the error implies either the file or folder is spelled incorrectly, or the filename itself doesn't exist...extra underscore or anything like that a possibility in the name?
i...
November 19, 2012 at 2:03 pm
well the details would help, but roughly it would look something like this:
if exists (select 1 from VW_products
where...
November 19, 2012 at 1:58 pm
Viewing 15 posts - 4,351 through 4,365 (of 13,464 total)