Viewing 15 posts - 5,626 through 5,640 (of 49,571 total)
Time to schedule a meeting with management and IT security people (and/or HR).
btw, zip passwords are trivial to crack, a quick google search should turn up a pile of tools...
June 10, 2015 at 2:22 pm
Or you could just
EXEC adasdb.master.sys.sp_executesql N'RESTORE DATABASE ETLNewTest FROM DISK = ''g:\MSSQL11.MSSQLSERVER\MSSQL\ETL_663.bak''';
June 10, 2015 at 9:25 am
Remote query timeout affects queries which this SQL Server instance (the one with the setting) executes against other database engines, via ether OPENQUERY or 4-part naming.
It has no effect on...
June 10, 2015 at 8:48 am
Please don't cross post.
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1693166-147-1.aspx
June 10, 2015 at 5:49 am
Add something into the catch block to send mail, or after the rollback add detail to a logging table.
June 10, 2015 at 5:24 am
Zohaib Anwar (6/10/2015)
if we dont put no lock then we get lots of deadlocks in production environment.
You prefer to add a hint that causes incorrect results rather than address the...
June 10, 2015 at 5:23 am
Are you sure the case statements are the problem?
And why the nolocks? I'd have thought that the people getting data from a transactions table would like their data correct all...
June 10, 2015 at 4:36 am
Computed column's the only way, but that'll be useless if the queries don't use the computed column. Also, don't assume that the DB is be case sensitive, check whether it...
June 10, 2015 at 4:20 am
You can't. Indexes are created on columns, not expressions.
You can, if you need to do this, create a computed column and index that. However that will only be useful if...
June 10, 2015 at 3:24 am
shaulbel (6/9/2015)
I think that this is the first step to be done when facing the "Recovery pending" issue.
The first step has to be to identify why the databases are in...
June 10, 2015 at 1:34 am
Yes, it matters, but not because it's contageous (it's not)
It matters because after a week or two or a month or ... you may not have the backups you need...
June 10, 2015 at 1:33 am
GilaMonster (6/9/2015)
ericpap (6/9/2015)
Joie Andrew (6/9/2015)
Another question, you say that you only have two logs available. If you look at the C:\Archivos de...
June 9, 2015 at 1:39 pm
You may get benefits from indexes, you may not. It depends on what kind of join SQL uses. Test and see. Even if you do, they probably won't be large...
June 9, 2015 at 1:29 pm
ericpap (6/9/2015)
Joie Andrew (6/9/2015)
Another question, you say that you only have two logs available. If you look at the C:\Archivos de programa\Microsoft...
June 9, 2015 at 1:25 pm
Grant Fritchey (6/9/2015)
So tempted to whip out "DO YOU KNOW WHO I AM?"
Need a hand somewhere?
June 9, 2015 at 1:19 pm
Viewing 15 posts - 5,626 through 5,640 (of 49,571 total)