|
|
|
January 2003 March 2003 April 2003 May 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 April 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Sql Server Replication Log file creation Posted by ferozsaiyed NO[at]SPAM gmail.com at 8/19/2007 11:05:41 PM I am working with SQL Server 2000 replication. Replication Occurs
Every One hour, and will updates the master and local servers.
I need a log file to be created with the same file name after every
replication. I have software that will monitor this file.The file is
created in Publisher's Serve...more >>
Backup & Recovery in Sql Server 2005 Posted by Jeff at 8/19/2007 9:45:15 PM Hey
I'm looking for a good article about backup and recovery in Sql Server 2005.
I want to read it as my boss wants me to be responsible for backups... not
just backup of sql server 2005 databases, but all the data in the
organization. I haven't done this before. wow what a challenge :)
...more >>
Server folders and files Posted by Guy at 8/19/2007 9:32:02 PM Hi All,
Currently in the process of upgrading from SQL Server 2000 to 2005 and
rewritting all the DMO code contained in my Access 2007 .ADP application to
SMO using .NET COM Interop.
The question I have is how do I get a list of the folders and files on the
server where the database resi...more >>
Using GUIDs as primary keys instead of INTs? Posted by morleyc NO[at]SPAM gmail.com at 8/19/2007 8:33:18 PM Hi, i have a number of remote databases which will need to merged
occasionally into a central database (once a week or so). To cut down
on any complicated synchronisation issues i have had the idea of using
GUIDs for the primary keys of tables instead of Int32. This would mean
any record created...more >>
Sql Server 2005 Online Documentation ?? Posted by Jeff at 8/19/2007 8:04:40 PM Hey
Please could some of you post the link to the online documentation of Sql
Server 2005 here?
I want to read about backup and recovery of sqlserver2005 databases.
cheers
Jeff
...more >>
Populating a detail table based on occasional header data. Posted by David C at 8/19/2007 4:54:01 PM Hi All, I am having a total mental blank at the moment, I am sure I have done
this before but I just cant remember how to do it!
I have a header table that has the values - Title | Issue | Cost.
The table is only updated with new values when there is a change in the cost.
An example would be...more >>
x64 version of SQL 2000? Posted by Mark J. McGinty at 8/19/2007 8:55:07 AM I've read several things that mention an x64 native 64 bit version of SQL
2K, but it doesn't seem to exist. I know there is an IA64 version for
Itanium... shouldn't they've been able to compile the same source base for
either 64 bit platform? I know there are alignment issue differences, but...more >>
sql server 2005 does not see subst / virtual drives Posted by shasson24 NO[at]SPAM yahoo.com at 8/19/2007 6:24:38 AM Hi,
I have been having some problems getting sql server 2005 SP2 to load
DBs from virtual or subst drives on windows XP. It is as if it cannot
see subst or virtual drives at all.
For example I have used the subst command to setup an L drive which
looks like L:\databases\my_DB.mdf. The rea...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SP Problem Posted by sam at 8/19/2007 12:00:00 AM The following SP worked when I wrote it and that was the last time it worked
SQL 2005 server
Works Sometimes om SQLExpress
CREATE PROCEDURE dbo.SP_Archive_Audit
AS
BEGIN
/* This Procedure will archive AuditTrail data to the Easy Archive Db
It will leave the last 10 days of data in t...more >>
HELP: Return these records, and *ONE* matching record for each... Posted by at 8/19/2007 12:00:00 AM I have a MS-SQL 2000 database with records like:
DOG-
CAT-
BIRD-
FISH-
DOG-47
DOG-48
CAT-AAA
CAT-123
HORSE-BBB
I need a SELECT statement that will give me a list of all the records
that end in "-"... and 1 (doesn't matter which) of its matching
counterparts.
So the results would ...more >>
CEILING with Significance Posted by Bassam at 8/19/2007 12:00:00 AM Hello
There is a CEILING function in Excel with an optional parameter called
Significance which returns nearst upper integer to that significance
example
CEILING(133.5) = 135
CEILING(22) = 25
CEILING(27.5) = 30
CEILING(91.2) = 95
IN SQL Server, the CIELING function does not have tha...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |