Viewing 15 posts - 1,906 through 1,920 (of 2,462 total)
i think you can do one thing
1. Add a column in source table "archive_flag"
2. set archive_flag = 1 for six month data
3 inset data into dest. table where...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 9, 2010 at 3:24 am
hennie7863 (4/9/2010)
deleting these statistics could be a quick win.
Are these Statisctics are manually created ??
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 9, 2010 at 2:25 am
I havent got much help from these deatils but it looks like the agent user doen't have access to the linked server.
Also refer this http://support.microsoft.com/default.aspx?scid=kb;en-us;906954
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 8, 2010 at 11:47 pm
YCH (4/1/2010)
"Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server..."
post the complete error and query you are using in job.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 8, 2010 at 5:54 am
r.rozeboom (4/8/2010)
Well it seems i found the trace at last were i found the evidence.
its better to keep A DDL trigger just for future prospect.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 8, 2010 at 5:48 am
You can also choose C2 Audit Trace , it is good option but the main limitation of the auditing is that it reduces the performance of the SQL Server. This...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 8, 2010 at 5:45 am
If your Database is handling good amount of transactions , growth of log is expected.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 8, 2010 at 5:01 am
I would go with Mirroring
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 8, 2010 at 4:55 am
- Win. (4/8/2010)
But i have to use in script, thats the criteria..
INSERT INTO LINKEDSERVER.Databasename.dbo.Tablename
Select * from DatabaseName.dbo.Tablename
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 8, 2010 at 3:14 am
Try this
DECLARE @availableSpace AS FLOAT
DECLARE @alertMessage AS Varchar(4000)
CREATE TABLE #tbldiskSpace
(
driveName VARCHAR(3),
freeSpace FLOAT
)
INSERT INTO #tbldiskSpace EXEC master..XP_FixedDrives
SELECT @availableSpace = ROUND((freeSpace)/1024,1) FROM #tbldiskSpace WHERE driveName = 'D'
SET @alertMessage = 'Free Space...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 7, 2010 at 8:56 am
Paul White NZ (4/7/2010)
DECLARE @test-2
TABLE (
ID ...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 7, 2010 at 6:58 am
hmm thats quite interesting, or i would say some poor SQL logic ;-).
Post the Stored Proc's script
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 7, 2010 at 6:22 am
these link can help you
http://www.sqlservercentral.com/articles/Integration+Services/61774/
http://www.sqlservercentral.com/Articles/SQL+Server+2005/SQL+Server+2005+-+SSIS/
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 7, 2010 at 6:06 am
- Win. (4/7/2010)
Anyone let me know how to correct and help me to do so.
Have you tested it ? i dont think you did.
Script is looking OK but better...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 7, 2010 at 5:58 am
SELECT p.TABLE_NAME,c.CONSTRAINT_NAME,c.COLUMN_NAME
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS p ,
INFORMATION_SCHEMA.KEY_COLUMN_USAGE c
WHERE CONSTRAINT_TYPE = 'PRIMARY KEY'
AND c.TABLE_NAME = p.TABLE_NAME
AND c.CONSTRAINT_NAME = p.CONSTRAINT_NAME
ORDER by c.TABLE_NAME
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 7, 2010 at 5:47 am
Viewing 15 posts - 1,906 through 1,920 (of 2,462 total)