Viewing 15 posts - 1,801 through 1,815 (of 9,720 total)
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
MSDN article on scripting variables with SQLCMD: https://msdn.microsoft.com/en-us/library/ms188714.aspx
Dave Pinal's thoughts[/url] on the subject.
DBA Stack Exchange http://dba.stackexchange.com/questions/13860/how-to-pass-in-parameters-to-a-sql-server-script-called-with-sqlcmd
So, if I understand this correctly, you can use the SQLCMD code to pull the...
April 28, 2016 at 8:49 am
Grant Fritchey (4/28/2016)
Brandie Tarvin (4/28/2016)
Grant Fritchey (4/28/2016)[/b]
I want to export large amounts of data. However, I don't want to use SSIS. I'm going to use SQLCMD.EXE. I need to...
April 28, 2016 at 8:35 am
Grant Fritchey (4/28/2016)[/b]
I want to export large amounts of data. However, I don't want to use SSIS. I'm going to use SQLCMD.EXE. I need to be able to script...
April 28, 2016 at 8:26 am
Grant Fritchey (4/28/2016)
Brandie Tarvin (4/28/2016)
Grant Fritchey (4/28/2016)
I want to export large amounts of data. However, I don't want to use SSIS. I'm going to use SQLCMD.EXE. I need to...
April 28, 2016 at 8:12 am
Grant Fritchey (4/28/2016)
I want to export large amounts of data. However, I don't want to use SSIS. I'm going to use SQLCMD.EXE. I need to be able to script...
April 28, 2016 at 8:01 am
TomThomson (4/26/2016)
Steve Jones - SSC Editor (4/26/2016)
See you there, and...
you have a car? I thought everyone in the UK just used trains.
Trains? UK rail fares are by far the...
April 27, 2016 at 8:11 am
Jacob Wilkins (4/26/2016)
That DENY didn't show up in the results of the query I posted earlier?It should have, so I'm curious why it didn't.
I just remembered. There was so...
April 26, 2016 at 11:46 am
Viewing 15 posts - 1,801 through 1,815 (of 9,720 total)