Viewing 15 posts - 6,481 through 6,495 (of 7,191 total)
Garry.
No. SQL Server service packs are cumulative, so you only need to restore the most recent.
John
March 20, 2007 at 5:03 am
Sean
Something like this? Not tested, so syntax may not be perfect.
CREATE TABLE #Gaps (RowNo int IDENTITY(1,1) PRIMARY KEY CLUSTERED,
AccNo int, Blanks int)
INSERT INTO #Gaps (AccNo)...
March 19, 2007 at 8:54 am
John
Yes, you can script the creation of the articles. I imagine the creation itself would be fairly reliable, but what happens after that - who knows? I've never worked with...
March 19, 2007 at 5:57 am
Lowry
Don't know. Are there any triggers defined on the subscriber?
John
March 16, 2007 at 9:45 am
Do both databases have the same indexes? Have you updated statistics and/or rebuilt indexes on the smaller database recently?
John
March 16, 2007 at 9:43 am
March 16, 2007 at 8:47 am
This is how you do it. If your foreign key constraints are on composite keys, then the logic gets a little bit more complicated, but it isn't difficult to work...
March 16, 2007 at 8:03 am
Assuming you're using SQL Server 2000, the sysreferences table should contain the information you're looking for.
John
March 16, 2007 at 7:10 am
John
It sounds like you're going to use replication and automate the creation of new articles every day or week after the tables have been created. Or perhaps you can use...
March 16, 2007 at 4:49 am
Colin
From Books Online (DBCC DBREINDEX topic):
DBCC DBREINDEX is not supported for use on system tables
John
March 16, 2007 at 3:29 am
Thiyagarajam
I think if you look up sp_xml_preparedocument and OPENXML in Books Online, you will be able to find a way to achieve what you're looking for.
John
March 16, 2007 at 3:22 am
Do you have a backup you can restore from without losing more than an acceptable amount of data?
March 16, 2007 at 2:04 am
TJ
Sounds like you have a corruption in your database and you need to run DBCC CHECKDB.
John
March 15, 2007 at 10:15 am
Dion
I haven't read through this, but it may have what you want.
http://www.simple-talk.com/sql/t-sql-programming/writing-to-word-from-sql-server/
John
March 15, 2007 at 10:07 am
Ben
Read up in Books Online about what the ISNULL and COALESCE functions do. In this instance they are equivalent.
If @FUND_ID is not null, the last line of your query will...
March 15, 2007 at 9:39 am
Viewing 15 posts - 6,481 through 6,495 (of 7,191 total)