Did anyone got solution for this issue?

Did anyone got solution for this issue? how can we stop getting this in Errorlog? its kind of spamming and annoying.

• This reply was modified 6 months, 2 weeks ago by  ~Sreejith G.

Excellent article! Good one Vishnu.

Wrong Answer! I provided 3 and it skipped the first three rows as its 1-based. I just got Erasmo,0 and Brett,2 in my table.

So Answer should be 2.

Load.Txt Content

-------------------

Heading

Name,Value

Sreejith,1

Erasmo,0

Brett,2

I lost a point :(... the answer should be "Yes"!

It should ROWCOUNT_BIG, its a system function!

Story of my previous company (mine was around 3000 employees company with a DBA team around 15 people in different verticals, sql server 4 people were there in which one is...

Whats the error message errorlog file of Sql Server showing?

Cant you fix the drive which find faulty...

Is it not mirrored? If you can bring back the drive with help of...

If you guys tried to attend all QOD question then you would have came accross one DLL Hell question. This is another way of asking the same question

Do it with Stored Procedure.... pass the table name and feild name as arguments.... I dont know what u really want and doesn't know when will u have tablename & feildname...

havent u see the previous post.......

we can use databasename.owner.SP to execute the same SP for different database.... I could find u replying...

'xp_regread'  doesnt have optional arguments to provide remote access..... u can run an remote SP by linking other server to ur server..... the linked server concept..... ohhhhh iam making it...

Sorry its,

'server_name.database_name.dbo.sp_name'

Typing mistake

Sure u can use it....

for eg...

database_name.dbo.sp_GetEmployees will point to particular database Employee table...

i.e A.dbo.sp_GetEmployees  -> point to A's Employee table...

I would add to other additional points...

1. Dont use 'sp_......'...