Viewing 15 posts - 5,836 through 5,850 (of 7,636 total)
This should get you started:
'truncate:
With Table
...
August 20, 2008 at 9:53 pm
You need to talk to your Network/Domain administrator.
August 20, 2008 at 8:49 pm
You usually want Servers to keep a static IP address for this very reason.
August 20, 2008 at 8:32 pm
Are you sure that the Owner (which may be different from the schema) is the same on all of them?
August 20, 2008 at 6:51 pm
Actually, I forgot the most important potential solution: RTRIM the MRN column before it gets stored in the first place.
August 20, 2008 at 6:38 pm
craig (8/20/2008)
rbarryyoung (8/20/2008)
August 20, 2008 at 12:57 pm
Assuming of course that you cannot just use the UPDATE's WHERE clause (presumably because there are other columns being updated is this same UPDATE statement, according to different criteria)
August 20, 2008 at 12:42 pm
kevriley (2/25/2008)
Is there any advantage/disadvantage to including the BEGIN and END block in a simple stored proc, i.e.CREATE PROC MyProc
AS
BEGIN
select col1, col2 from Mytable
END
no control-flow statements, no transaction.
Disadvantge: extra...
August 20, 2008 at 12:08 pm
jlp3630 (8/19/2008)
August 20, 2008 at 10:03 am
DISTINCT is a SELECT keyword, not a function.
Try this:
Select cmd as [-- Commands:] From (
SELECT DISTINCT 'DBCC DBREINDEX(' +
(o.name + ',') + -- table name
''' ''' + ','...
August 20, 2008 at 9:28 am
avamin (8/20/2008)
Though it's possible for the app to impersonate another windows user, I agree, SQL Login is easier and is also easier to implement than using approle.
Well, it's not...
August 20, 2008 at 9:17 am
Viewing 15 posts - 5,836 through 5,850 (of 7,636 total)