Viewing 15 posts - 736 through 750 (of 11,676 total)
WhiteLotus (4/30/2015)
Btw do you know how to reduce data file ? I know how to reduce trans log file ( by doing Backup trans...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 30, 2015 at 1:24 am
WhiteLotus (4/30/2015)
Actually What I am worried is about someone created new database someday without my knowledge and he doesnt understand about recovery model ... Thats will...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 30, 2015 at 1:11 am
WhiteLotus (4/29/2015)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 30, 2015 at 12:51 am
Steve Jones - SSC Editor (4/29/2015)
Some of the downloads don't even let you enter a product key, but as Grant mentioned, it's for development.Express, Standard, Enterprise for production.
And of course...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 29, 2015 at 2:40 pm
treyagrimes (4/29/2015)
I'm not sure what a CDC is?
The Oracle table does have a mod_date so that might be the column to key off of. Could you...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 29, 2015 at 6:49 am
Phil Parkin (4/29/2015)
Unless you've paid over US$10,000 for a licence, you cannot use it as Enterprise on a production server.
$10,000? That's a bargain 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 29, 2015 at 3:17 am
charipg (4/29/2015)
it sending blank email if the table is empty.i dont want to receive mail if the the table is empty.
Ah, I see.
You are currently checking if the string "select...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 29, 2015 at 2:11 am
1. There is no need to shrink them. If your transaction logs are full, take transaction log backups.
(and how big can the transaction log for the model database be?)
To quote...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 29, 2015 at 2:09 am
sureshjevani 78421 (4/28/2015)
Can someone help me with the syntax of scripting out the linked server. Thanks
Can you give a bit more explanation on what exactly you want to accomplish?
Btw, you...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 29, 2015 at 2:03 am
No idea. Are you sure there are no rows hidden somewhere or on another page?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 29, 2015 at 2:02 am
Right now, how your code is structured, there won't be an email sent if (@mSql2 IS NULL ). So what else do you want to accomplish?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 29, 2015 at 2:00 am
No idea about the corrupted rows.
Don't know if it's possible. Maybe you can check out bpc.
First result from google for sqlbulkcopy class:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 29, 2015 at 1:58 am
This script task sets the value of the variable str_ArchiveFileName to something like \\servername\d$\ftp\Test\Archive\Journal - 2015-04-29.csv
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 29, 2015 at 1:37 am
What do you want to do exactly?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 29, 2015 at 1:35 am
tfendt (4/28/2015)
I am using the new 2012 Integration Services Catalog with Project deployment. I can run the package...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 29, 2015 at 1:33 am
Viewing 15 posts - 736 through 750 (of 11,676 total)