Viewing 15 posts - 46 through 60 (of 497 total)
You can configure your two digit year cutoff so that it displays the correct century. http://msdn.microsoft.com/en-us/library/ms191004.aspx
July 31, 2014 at 11:11 am
It depends on the read/write ratio of your database. If you are mainly a read-only database (80% reads or more) then I would suggest your mdf file be moved over...
July 31, 2014 at 7:51 am
Ola Hallengren has already done the work for you. Check out his scripts[/url] for performing index maintenance and also backups and restores. These scripts are highly regarded in the SQL...
July 31, 2014 at 7:44 am
Don't make this harder then it needs to be. Either script out the "must have" jobs and then restore MSDB and reapply the jobs from the script or restore MSDB...
July 31, 2014 at 7:41 am
shiv-356842 (7/30/2014)
For pre-paring report I need this format report on instance.
Database Name Database User Name Database User Permission
Request to you please give any ideas on...
July 30, 2014 at 1:42 pm
Do you have a backup for the entire MSDB? If so, you can simply restore that over the new MSDB database.
July 30, 2014 at 1:32 pm
ScottPletcher (7/30/2014)
Sean Lange (7/30/2014)
ScottPletcher (7/30/2014)
Keith Tate (7/30/2014)
What can happen if null is not defined?
If you don't set the NULL option then it will be nullable.
create table Test1 (ExpirationDate datetime);
go
That's not...
July 30, 2014 at 10:30 am
You can create User Defined Data Types that had the necessary Null values you want defaulted for that data type, but you would have to use that data type when...
July 30, 2014 at 9:05 am
SELECT DISTINCT C1.IDX
, C2.C2FirstName
, C1.C1FirstName
, CASE WHEN CHARINDEX(' ',C2.C2FirstName) > 0 THEN PARSENAME(REPLACE(C2.C2FirstName, ' ', '.'),...
July 30, 2014 at 8:55 am
Is required to set the null value after the field type?
It is not required.
What can happen if null is not defined?
If you don't set the NULL option then...
July 30, 2014 at 8:50 am
You have posted 4 or 5 different times about this query. If you want it to work correctly please give us the all the create table statements (for all tables...
June 30, 2014 at 8:11 am
Please don't post the same question in multiple forums. Here is a link to the original http://www.sqlservercentral.com/Forums/Topic1586485-391-2.aspx#bm1586578
June 26, 2014 at 1:31 pm
Please, Please, Please add the code to create the tables and some sample data along with the desired output. We are wasting time trying to guess what you want and...
June 26, 2014 at 9:48 am
I'm not sure what the question is. It seems like you have added the table are you not getting the results that you expect? If not, what are you getting...
June 26, 2014 at 8:56 am
Click on the word blog it is a link
June 26, 2014 at 8:39 am
Viewing 15 posts - 46 through 60 (of 497 total)