Topics
Started by
Posts
Last post
Hi Can some one shade light on pros and cons of DR solutions of Mirroring, Log Shipping, geoCluster…
3 replies
Hey all, Glad to be part of this community. I have ran into a problem with my database that involve…
1 replies
Hi Everyone, I need to know whether we can use corelated sub query in case satatements. My requieme…
3 replies
Hi, I need write a regular expression: 1. Must start in caracter - next to any letter. 2. Must end …
2 replies
Hi All, I am trying to write a trigger that dynamically creates an audit trail for data change, whe…
7 replies
how to insert data into table having 5 columns and text file having 3 columns. Example: Table has …
1 replies
I have a cursor and transaction within the Procedure.The sample is given below. Exe: DECLARE cursor…
5 replies
Hey, We recently upgraded our SQL server 2000 instance to SQL Server 2008 x86... I've been able to…
2 replies
I have a cube with measure "Chrg" on Products and a Date Dimension with "EffectiveDate". I need he…
1 replies
how can i script and included index? (the scripting ability in sql2005 dosen't include included ind…
1 replies
Hi All, I have heard a weird statement in one of the training sessions for Sql server 2005 that SP3…
4 replies
It probably will be the classic answer, It depends... 🙂 The thing is that, unfortunately, there are…
8 replies
In a stored procedure i am using cursor inside the BEGIN TRY n END TRY... in CATCH block, how can i…
3 replies
<pre> I am following the book "Real World SQL Server Administration with Perl" by Linchi She…
1 replies
I need to calculate the number of nights a tenant rents an apartment each month, but I don't always…
29 replies
Viewing 15 topics - 2,251 through 2,265 (of 10,974 total)
You must be logged in to create new topics.