Viewing 15 posts - 17,836 through 17,850 (of 59,069 total)
Here's what I'm talking about... this checks to find out what the current recovery model is so that you can make better decisions as to what kind of backup is...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 17, 2016 at 12:38 pm
Jeff Moden (4/17/2016)
SELECT LastFullBackupDT = MAX(backup_finish_date)
FROM msdb.dbo.backupset
WHERE database_name = 'yourdatabasenamehere'
AND recovery_model...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 17, 2016 at 11:56 am
This should help you get started...
SELECT LastFullBackupDT = MAX(backup_finish_date)
FROM msdb.dbo.backupset
WHERE database_name = 'yourdatabasenamehere'
AND recovery_model <>...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 17, 2016 at 11:49 am
avraham.elad (4/17/2016)
hi ,i dont understand iam pagei read sevral post and is dont get it,
somone please explain this without qoute msdn ?
Without knowing why you need to understand IAM...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 17, 2016 at 10:45 am
manie (4/15/2016)
It would be interesting to find out what percentage of the world's programmers rely on forums like SSC to actually do their job (sorry, have the job done for...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 17, 2016 at 10:05 am
Just in case you've not already tried...
Since this isn't a production box, do the "normal" thing... something may have gone haywire with Windows or SQL Server express. Try rebooting...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 17, 2016 at 8:53 am
qwerty.qwertz (4/17/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
April 17, 2016 at 8:42 am
richardmgreen1 (4/14/2016)
If only......
We get the CSV files as a data extract (I haven't got a clue what format the back end of the application runs on).
This is also a...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 17, 2016 at 8:27 am
fareedhmohamed (4/17/2016)
USE [Supermarket]GO
/****** Object: Table [dbo].[Customer] Script Date: 17/04/2016 13:44:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Customer](
[CustomerID] [varchar](10) NOT NULL,
[FirstName] [nvarchar](50) NULL,
[Surname] [nvarchar](50) NULL,
[Gender]...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 17, 2016 at 7:45 am
If you click the QUOTE button on this post, you'll see how to use the "IFCode Shortcuts" that you can see to the left of your post when you're creating...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 16, 2016 at 7:34 pm
natigsqlserver (4/16/2016)
i have very interesting qeustion
can we comparing two another files with sql server
for example
in varbinary column have a pdf format file
in inserting new data in...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 16, 2016 at 11:39 am
Jeff Moden (4/15/2016)
Sgar... (4/15/2016)
In above examples you have used Set @dbname= 'database name'.I am taking this input from Stored procedure input. How can you help?
I'm curious... have you ever written...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 16, 2016 at 9:02 am
dxu (4/14/2016)
I have scheduled full SQL backup on 1AM every morning and then two differential backups on 7AM and 1PM. I have also put hourly log backup in place...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 15, 2016 at 8:44 pm
Heh... wow... this thread certainly jumped the track. 😉
The original post is pretty clear. Everything flies when the last condition is removed even though a shedload of...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 15, 2016 at 8:29 pm
Sgar... (4/15/2016)
In above examples you have used Set @dbname= 'database name'.I am taking this input from Stored procedure input. How can you help?
I'm curious... have you ever written a stored...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 15, 2016 at 8:11 pm
Viewing 15 posts - 17,836 through 17,850 (of 59,069 total)