This is something you could test.

CREATE TABLE #S(FirstName VARCHAR(20), LastName VARCHAR(20), Address VARCHAR(20), City VARCHAR(20), State VARCHAR(2)

, SSN VARCHAR(20), SomeNumber VARCHAR(20))

INSERT INTO...

This might be of use:

http://technet.microsoft.com/en-us/library/ms166351(v=sql.90).aspx

Nice simple question

Greg Edwards-268690 (10/1/2013)

---

ChrisM@Work (10/1/2013)

---

Chap who sits opposite me here is visiting SF next week and has just found out that Alcatraz has closed. He may be the first to start...

Help those who want to help you. Please post the table definitions, the trigger code, along with some sample data.

To do this easily refer to the link in my...

Nice question to end the week ............

The Questions are:...

First of all, this proc is NOT mine but ran across it here on SSC

CREATE PROC [dbo].[SQL_Last_Started]

/* Brian K. McDonald, MCDBA, MCSD

...

oops

This will give you the current size of the database;

select SIZE AS '8k PAGES' FROM sys.database_files WHERE TYPE = 0

run this as a select, inserting the output into a table.

Then...

This might be what you are looking for:

SELECT CONVERT(VARCHAR(7), GETDATE(), 111) AS [YYYY/MM]

Result:

2013/09

]

You might want to attempt this:

CREATE TABLE #LogData

(CurrentLSNsysname varchar(50),Operationsysname varchar(50)

,Contextsysname varchar(50),

TransactionIdsysname varchar(50),LogBlockGenerationint int)

insert into #LogData...

Checked using my play database and it went back to 9/17 (2 days) and my play DB gets shut down each night.

But of course that is a very, very short...

Not sure if this will give you all you require, have you tried:

Using SSMS

Right click on DB

Select Reports

Click on Schema...

defyant_2004 (9/18/2013)

---

Hello,

I will be taking over the role of a SQL Server DBA for my company. Our SQL Servers have always been maintained by our Server Admins. I...