Viewing 15 posts - 1,786 through 1,800 (of 9,715 total)
Lynn Pettis (4/29/2016)
Brandie Tarvin (4/29/2016)
Luis Cazares (4/29/2016)
Or install more memory.
Umm, that won't work. SSMS has the memory limitation. Not my desktop.
Per Microsoft:
Note SSMS is a 32-bit process. Therefore, it...
April 29, 2016 at 10:47 am
jasona.work (4/29/2016)
Grant Fritchey (4/29/2016)
April 29, 2016 at 10:46 am
Okay. This is what I ended up with in order to make everything readable and easier to find the jobs I need to delete from the script. Also, I ran...
April 29, 2016 at 7:59 am
Eirikur Eiriksson (4/29/2016)
Out of curiosity, how many jobs do you have?😎
I have not counted. I have to pull them from several servers down to one or two scripts.
April 29, 2016 at 7:51 am
Luis Cazares (4/29/2016)
Or install more memory.
Umm, that won't work. SSMS has the memory limitation. Not my desktop.
Per Microsoft:
Note SSMS is a 32-bit process. Therefore, it is limited to 2...
April 29, 2016 at 7:50 am
Luis Cazares (4/29/2016)
SELECT 'IF EXISTS (SELECT 1 FROM msdb.dbo.sysjobs_view WHERE name = N' + QUOTENAME( name, '''') + ')
...
April 29, 2016 at 7:39 am
HA! Even SSMS agrees I have too many jobs. Using just a part of the code from Lowell's second link (to create the drop job stuff), I got
An error occurred...
April 29, 2016 at 7:15 am
Lowell (4/29/2016)
select
'IF EXISTS (SELECT job_id FROM msdb.dbo.sysjobs_view WHERE name = N''' + name +...
April 29, 2016 at 6:55 am
So I had my dose of mild frustration followed up by a funny this morning.
A dev asked me to restore two Test 2012 databases down to SQL 2k8. As I'm...
April 29, 2016 at 6:47 am
I think I found what I needed. I will know when I've tested it.
From BOL on Integration Services job steps:
Use 32 bit runtime
Indicate whether to run the package...
April 29, 2016 at 6:21 am
Can someone help me with "hacking" the Script Job As Drop code?
I don't really want to hack MS's version so much as look at it and adapt it to my...
April 29, 2016 at 5:35 am
Eirikur Eiriksson (4/29/2016)
BLOB_EATER (4/29/2016)
GilaMonster (4/29/2016)
GilaMonster (4/27/2016)
BLOB_EATER (4/27/2016)
GilaMonster (4/26/2016)
BLOB_EATER (4/26/2016)
GilaMonster (4/26/2016)
SQLRNNR (4/26/2016)
April 29, 2016 at 5:34 am
mbraman (4/28/2016)
I apologize - it's been very difficult to explain. No need to reply anymore.
I hope you're not giving up because of what I said. The intent was not...
April 29, 2016 at 4:17 am
GilaMonster (4/29/2016)
GilaMonster (4/27/2016)
BLOB_EATER (4/27/2016)
GilaMonster (4/26/2016)
BLOB_EATER (4/26/2016)
GilaMonster (4/26/2016)
SQLRNNR (4/26/2016)
April 29, 2016 at 4:14 am
mbraman (4/28/2016)
The data flow is - data in sql server goes to tabular model to tableau.
The "Field..." are filters in table.
So what...
April 28, 2016 at 11:54 am
Viewing 15 posts - 1,786 through 1,800 (of 9,715 total)