Viewing 15 posts - 46 through 60 (of 3,221 total)
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...
October 4, 2013 at 1:59 pm
This might be of use:
http://technet.microsoft.com/en-us/library/ms166351(v=sql.90).aspx
October 2, 2013 at 6:30 am
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...
October 1, 2013 at 8:06 am
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...
September 29, 2013 at 2:03 pm
colt (9/25/2013)
I picked the correct answer of 5 hours.But got...
Sorry - you were wrong
Correct answer:
5 hours is returned by the SELECT statement, The create table statement succeeds
The Questions are:...
September 25, 2013 at 9:40 am
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
...
September 25, 2013 at 6:20 am
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...
September 23, 2013 at 8:36 pm
This might be what you are looking for:
SELECT CONVERT(VARCHAR(7), GETDATE(), 111) AS [YYYY/MM]
Result:
2013/09
]
September 22, 2013 at 3:35 pm
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...
September 20, 2013 at 7:14 am
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...
September 19, 2013 at 8:09 am
Not sure if this will give you all you require, have you tried:
Using SSMS
Right click on DB
Select Reports
Click on Schema...
September 19, 2013 at 7:28 am
defyant_2004 (9/18/2013)
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...
September 18, 2013 at 2:26 pm
Viewing 15 posts - 46 through 60 (of 3,221 total)