Viewing 15 posts - 7,156 through 7,170 (of 13,469 total)
from TSQL, it's very difficult; there's no native way to get the scripts in TSQL; most people end up calling something else that calls SMO via xp_cmdshell, and brings it...
July 15, 2011 at 6:55 am
C.K.Shaiju (7/15/2011)
Here I have 15 systems which have been already installed with SQL Server. But now I have to find out which all systems are installed as CLIENT and which...
July 15, 2011 at 6:12 am
stewartc-708166 (7/15/2011)
Features Supported by the Editions of SQL Server 2008 R2
The google force is strong in this one....
July 15, 2011 at 6:00 am
not sure what you mean.... the machine with the MSSQLSERVER service is the server...but "client" software can be installed on the server or on other machines...
what , for you, do...
July 15, 2011 at 5:52 am
you have a pretty wide array of encryption choices, but as Perry Whittle mentioned, they require a schema change...you'll need to change a varchar column to varbinary, for example using...
July 15, 2011 at 5:44 am
--no transactions at all for a givien client:
SELECT * FROM clients
LEFT OUTER JOIN clienthistory
ON clients.clientID = clienthistory.clientID
WHERE clienthistory.clienthistoryID IS NULL
--the balance of all transactions is zero.
SELECT * FROM...
July 14, 2011 at 2:13 pm
you'll have to show the code that is being called to send the mail...it sounds like you might be building a string, instead of using parameters.
if you are building a...
July 14, 2011 at 12:56 pm
upstart (7/14/2011)
... either covered their tracks really, really well or our default 'black box' trace for some reason did not capture anything regarding it....
In my career I've seen mostly careless...
July 14, 2011 at 12:50 pm
the trimmed field needs to be aliased...same as if you did a min or max, for example.
SELECT DISTINCT
T2.Number
FROM table1 AS T1
INNER JOIN (SELECT
...
July 14, 2011 at 11:07 am
don't know if you use other schemas than the default dbo, but this slight modification to the model prevents dbl.tblBananas from being dropped, but not TestSchema.tblBananas; probably a good enhancement...
July 14, 2011 at 10:36 am
scoleman_cambridge (7/14/2011)
July 14, 2011 at 10:07 am
i've done something like this with putting icons in a database, and i get a CRC value from vb.NET,and store it along with the varbinary(max) in the row;
it seemed a...
July 14, 2011 at 9:55 am
yes.
i just created and tested this trigger as a prototype.
i've created 4 tables, and tried to delete them, only one is successful, the others raise the expected error.
CREATE TRIGGER [TR_ProtectCriticalTables]
ON...
July 14, 2011 at 9:44 am
well good we eliminated that as being a possible issue.
how is the data being migrated from source to destination?
Somewhere in that process, it seems, would be the issue.
is it a...
July 14, 2011 at 9:31 am
Viewing 15 posts - 7,156 through 7,170 (of 13,469 total)