I want to be able to see when a backup file was created. Does SQL Server provide a way to add the current date and time to my backup file filenames?
SQL Server records the date and time inside the backup file...
I have two questions about backing up and restoring files. First, how can I determine when my last backup occurred? And second, how can I retrieve the files from the list in the backup folder and restore them...
I'm using transactional replication with SQL Server 2000 Standard Edition Service Pack 4 (SP4) on Windows 2000 Server.The replication worked fine until the night we tried to archive more than 37 million records from...
I've been having trouble using SQL Server 2000 transactional replication to transfer Identity field values. In my environment, both the publisher and subscriber are SQL Server 2000 servers running Service Pack 3 (SP3)...
I understand that SQL Server 2005 is completely based on .NET Server and as such is integrated with Visual Studio .NET. Does this integration mean that I can use the CREATE ASSEMBLY command to register the DLLs I've...