cjohn5552 (11/28/2011)

---

Hey all,

I am running into an issue and I was hoping someone could explain why it was happening. I was trying to restore a database on a SQL instance...

znkin (11/28/2011)

---

Thanks all for the replies...

Apart from what was suggested by all would it help if I made a view and transferred all data in a separate table for the...

It basically depends on your log backups size & the amount of space you have.

1. You can get the information about the log backup files which have been restored successfully...

Graeme100 (11/22/2011)

---

Hi,

I think you need to read a little bit more about replication. Especially if you are supporting a production server.

Your answers to my questions suggest a very limited knowledge.

My...

applebyte (11/22/2011)

---

Hello everyone,

I'm running an openquery with stored procedure sp_msforeachdb and get an error which is difficult to understand:

Msg 208, Level 16, State 1, Procedure sp_MSforeach_worker, Line 102

Invalid object...

Go for anything, any work you find in the field of SQL Server. Obviously you can not get the DBA job right away, but certainly you can get a chance...

koolme_85 (11/27/2011)

---

tableA ,TableB, tableC , tableD , tableE,

colA. colb ,colc , colD , colE,

s, p, d, f, g,

q, w, r, t , u,

table 1

col1,col2,col3,col4,col5,col6,col7,col8,col9,col10

s,p,d,f,g,X,Y,Z,null,null,

q,w,r,t,u,X,Y,Z,null,null,

x , y and z are hard...

bitbucket-25253 (11/26/2011)

---

If you are using as SP or even a dynamic T_SQL statement to do the insert, I suggest that you modify it to include a TRY CATCH block, so...

petemetz (11/10/2011)

---

Hello all-

I'm running an application that uses SQL Server 2008 R2 as the backend. What I need to do is allow 'User1' to be able to connect to...

Banana-823045 (11/8/2011)

---

I have a certificate login that is meant to manage logins and in one of stored procedure signed by the certificate user, we grant or revoke CONNECT SQL permission...

You can use "SQLCMD -Lc" from CMD to produce the list of the SQL server instances on your network.

Albeit , keep in mind that the output of this command...

In first glance, it looks like a hardware fault. There should be some bad sectors in the disk you are using for the log file.

Have you tried to take the...

agiangone (11/23/2011)

---

Actually yes, even though the highest selectivity is on the other column. The provider only has 5 different values and it is filtered in the index to two. I...

Hi XBoxOwn,

Would you please provide information about the problem you are facing ?? All I can see is the script for a function.

Regards,

Sujeet

Hahahahha ... 😀 No I am not going to make any product.

Well, Thanks for the reply Dev.

As I mentioned in my question itself, I was reading about the SRDF...