Viewing 15 posts - 1,981 through 1,995 (of 49,571 total)
Just the stored procedures without the database? Put them in source control, either manually via scripting or via a tool that interfaces directly.
December 19, 2016 at 8:13 am
BLOB EATER (12/19/2016)
GilaMonster (12/19/2016)
Grant Fritchey (12/19/2016)
BLOB EATER (12/19/2016)
I am 90% sure that I will be going to sqlbits in April, anyone else know if they will be there?
I submitted sessions...
December 19, 2016 at 8:10 am
Grant Fritchey (12/19/2016)
BLOB EATER (12/19/2016)
I am 90% sure that I will be going to sqlbits in April, anyone else know if they will be there?
I submitted sessions today. Fingers crossed...
December 19, 2016 at 7:45 am
SQL Guy 1 (12/15/2016)
Yesterday our server has crashed and I need to find out exact time. In other words, since when SQL Server has become unresponsive
That's probably not going...
December 19, 2016 at 6:22 am
Script the job, put the script into source control.
December 19, 2016 at 4:06 am
ramyours2003 (12/19/2016)
no problem in my system but I would like to know how can we trouble shoot the lazy writer issues ?
There's not really much configuration you can do...
December 19, 2016 at 3:53 am
atulyan.aries (12/19/2016)
Thanks for your response. can this be upgraded directly to SQL 2014?
No, and in-place upgrades are not a good idea for production systems (plus there's the small matter of...
December 19, 2016 at 3:07 am
In-place upgrade (not recommended) or side-by-side/new server?
December 19, 2016 at 2:45 am
SELECT *
INTO Table3
FROM Table1 CROSS JOIN Table2
December 15, 2016 at 8:27 am
It probably won't work correctly.
Why are you using sp_addlogin though? It's deprecated, has been since SQL 2005 and shouldn't be used any longer. It doesn't have support for any features...
December 15, 2016 at 5:23 am
johnwalker10 (12/14/2016)
Note: It fixes the corrupt SQL database but youmaywill lose some data.
It will cause data loss, not may.
Sammy, best thing here is restore to your last good...
December 15, 2016 at 2:47 am
marc.corbeel (12/14/2016)
Found a very simple solution to my problem...
create procedure stp_test (@only_this_record int)
as
begin
select * from test where (field1=1) and ...etc...
and (id=@only_this_record or @only_this_record=0)
end
I hope you don't need decent performance from...
December 15, 2016 at 2:44 am
Sioban Krzywicki (12/14/2016)
Things are going well. New job that I like a lot better. How's things with you?
It's been an interesting couple of years (in the Chinese curse sense unfortunately),...
December 15, 2016 at 2:40 am
Don't use those, they're deprecated and old (SQL 2000). Use the DDL statements instead
CREATE LOGIN ...
CREATE USER ...
ALTER ROLE ...
December 15, 2016 at 2:38 am
Viewing 15 posts - 1,981 through 1,995 (of 49,571 total)