Topics
Started by
Posts
Last post
I am in the process of cross training a DBA. At this point, he has very little knowledge of ERwin 7…
6 replies
Morning, I created a batch file to bcp xml out of tables. When executing the file it just loops on …
2 replies
By: whojdysz
Hi, I have detached a database having Filestream and then moved the mdf,ldf and filestream folder t…
4 replies
By: SQLer
As mentioned in the link below, https://www.codemag.com/article/0605061/SQL-Server-2005-Query-Notif…
1 replies
I am getting below Deadlock Error: Transaction (Process ID 1900) was deadlocked on lock res…
2 replies
I created a transaction stored procedure adding a line as Begin Tran But someone told me that need …
12 replies
Does XML datatype with NULL Value in SQL Server 2008 consume any storage space? As mentioned in htt…
5 replies
i'm writing below this code.. exec msdb..sp_send_dbmail @profile_name = 'local',@recipients='chintu…
81 replies
I have a table with 1 lac rows with id and bit columns. The size of the table is 13.523MB. If I add…
5 replies
I have two databases: Db1 and Db2. For security (and other) reasons I don't allow the database user…
2 replies
By: JacekO
Hi Gurus, as a adhoc DBA I have a unique request to assign non-admin user the ability to only view …
5 replies
Hi I ran into an issue parsing xml, Here is a sample <catalog issue="spring" date="2015-04-15"&g…
1 replies
Consider when ,userA begins transaction , does 'update','insert','delete' but commit transaction is…
10 replies
Is foreign key constraint possible in xml data type? OR Is it possible to mention multiple Foreign …
2 replies
SQL 2008 instance was running on a VM. It ran out of space so IT decided to shutdown and expand the…
8 replies
Viewing 15 topics - 1 through 15 (of 30,197 total)
You must be logged in to create new topics.