Viewing 15 posts - 841 through 855 (of 1,079 total)
select @@version
union
select current_user+' '+'as'+' ' +system_user
something like this?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 19, 2010 at 8:52 am
try:
http://www.connectionstrings.com/
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 19, 2010 at 4:58 am
make use of a table, with a 0 and 1 value, with date.
each time the job has started, it writes a date and value of 1 in the table.
configure the...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 16, 2010 at 8:17 am
The sequence requires an older log to be restored first and then the newer one.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 16, 2010 at 3:24 am
update stats on your tempdb after shrink.
use tempdb
go
exec sp_updatestats
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 15, 2010 at 12:58 am
and what was it?
it's always good practice to explain the solution, whenever we can't assist you, that way, we learn as well.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 15, 2010 at 12:54 am
script out the keys, NC Indexes, etc and add them to the bottom of your script (create table script)
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 15, 2010 at 12:41 am
Do a repair on your SQL 2000 installation.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 15, 2010 at 12:38 am
with regards to? using it as a source/destination? please give more detail.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 15, 2010 at 12:37 am
Yes, because there aren't any.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 15, 2010 at 12:31 am
have your statement look at everything > than....
SELECT [Yesterday] = DATEADD(DAY, -1, DATEDIFF(DAY, 0, CURRENT_TIMESTAMP));
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 15, 2010 at 12:02 am
duplicate post.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 14, 2010 at 11:29 pm
I'm using SQL 2005 Express, and scripting the dbo.backupFile table on msdb, scripts out everything, columns, keys, indexes etc.
USE [msdb]
GO
/****** Object: Table [dbo].[backupfile] Script Date: 04/15/2010...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 14, 2010 at 11:27 pm
MS SQL has built in functionality to do this...
log ship, replication......
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 14, 2010 at 11:22 pm
sp_helpdb master
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 14, 2010 at 11:16 pm
Viewing 15 posts - 841 through 855 (of 1,079 total)