Wondering what the best practice or best approach would be to solving a problem. We are currently migrating from IIS to Sun Java Web Server. This is being done to address various security flaws in IIS. So the plan is to move all the applications and database to a development / test environment and run […]
2004-01-27
1 reads
i put the table name in place of TableName in your code; but I'm getting an empty set when I run the code. how else do i need to modify the code?
2004-01-27
I use these 2 statements as two different steps in a job to back up the log and then truncate it. Works well.Step 1BACKUP LOG [MyDB] TO DISK= 'D:\Backup\MySqlServer\MyDB\MyDbLog.dat' WITH NOINIT , RETAINDAYS=2, NOUNLOAD , NAME = N'MyDB Translog Backup', NOSKIP , STATS = 10, NOFORMATStep 2USE master BACKUP LOG MyDB WITH NO_LOG GO USE MyDB […]
2004-01-07
1 reads
weissa, Can you answer jxflagg Last question? I have no clue about what are your presentation requeriments and That makes it harder for me so I am guessing now: Suppose you have TableChild (ChildID int, ParentID int , Property varchar (100)) You Could Do: Declare @strAllChilds varchar(4000) Declare @MasterRecordID int SET @MasterRecordID = X SELECT […]
2003-12-24
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-12-15
By Steve Jones
In a previous post, I set up the basic databases for the PoC project...
By Steve Jones
Today’s coping tip is to plan something fun and invite others to join you....
When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...
I'm sure this has been asked many, many, many times and hoping several optimal...
How do I determine the initialization status of a subscription with T-SQL -- i.e,...
Has anyone migrated databases from on premise SQL Server to Azure Managed instance? If...
Ask SSC