Viewing 15 posts - 2,026 through 2,040 (of 13,469 total)
like this, i think?
with MyCTE
AS
(
with MyCTE
AS
(
select row_number() over(
partition by Job_ID,run_date,step_id
order by run_date desc,run_time desc,step_id) As RW,
* from msdb.dbo.sysjobhistory
)
delete FROM MyCTE WHERE RW >1
February 9, 2015 at 10:07 am
the users themselves are contained in the databases themselves,
if you are migrating, maybe you mean migrating logins to a new server via the ms proc sp_help_revlogins?
for an existing instance,...
February 9, 2015 at 9:52 am
data in a consumable format:
i got tired of the solution just cleaning up the data, and gave up at that point.
;WITH MyCTE([ID],[Dept],[Address],[GroupID ])
AS
(
SELECT '165683','32 ','P O BOX 602','2' UNION...
February 9, 2015 at 7:27 am
my best guess base don the limited information.
SELECT *
FROM Customer
--nothing in last 3 monts
WHERE CustomerCode NOT IN(SELECT o.CustomerCode
...
February 9, 2015 at 5:51 am
jahid786 (2/6/2015)
February 6, 2015 at 1:17 pm
i do this ALL the time. i have suites of procedures using this ability.
it requires a few things
it must be placed in the master database. (not some DBA_Utilities or...
February 6, 2015 at 11:44 am
i think the issue is connecting to an exchange server is not the same as connecting to an SMTP server, even if that server happen to be an exchange server.
the...
February 6, 2015 at 6:32 am
similar to what Igor posted, the code below can help find objects that reference a linked server, but can't find adhoc usage of a linked server, for example if an...
February 5, 2015 at 5:51 am
I'd go for local reachouts first. put together a letter of introduction/highlights of exactly what your skillset can contribute. this would not be a resume, but direct experience someone...
February 5, 2015 at 5:34 am
nope, it is not possible to deny a sysadmin access to anything.
permissions checks are shortcutted if you are sysadmin, and all deny/revoke permissions you might create are ignored.
the only solution...
February 4, 2015 at 2:36 pm
wow, i fiddled with doing this with substring and charindex, and it is so ugly compared to using a delimitedsplit.
/*--Results
(No column name) UNC ...
February 4, 2015 at 2:33 pm
suppiunna (2/4/2015)
February 4, 2015 at 10:45 am
to satisfy that specific query, i think an index on the four columns involved int he WHERE clause is needed, and INCLUDE all the columns in the SELECT, right?
CREATE INDEX...
February 4, 2015 at 10:27 am
you probably want to fix the trigger., or remove the trigger completely and move the migration from one table to another to a job that runs every x minutes.
as a...
February 4, 2015 at 10:13 am
it is not possible to deny a sysadmin access to anything.
permissions checks are shortcutted if you are sysadmin, and all deny/revoke permissions you might create are ignored.
the only solution...
February 4, 2015 at 9:02 am
Viewing 15 posts - 2,026 through 2,040 (of 13,469 total)