Hi

I've had the same problem and it was caused by the dbcc checkdb that hung on the log file not being able to write for some reason. I am unable...

"ALTER TABLE TNAME ALTER COLUMN VERSIONID CHAR(10);

Table contains 4 crore data in it.

It took me 40 minutes to execute the above statement."

The reason for this is that sql is adding...

hi

In my opinion the best would be creating a new table with the changed column and just transfering the data there. Then renaming the new and old table. Then create...

Hi

Microsoft GUI is following best practice.

If you do it with alter table a new field is added to the table (old col invisible and not used but still takes up...

It is sorted. There was a problem with the copy of the file. Recopied the file and all ok now.

That was my first thought aswell. I did check it again and there is no missing log file. Why is the system alowing me te redo a restore that was...

Hi

For all those who had the same problem. I found the problem on my side. One of the ad groups that the user belonged to was denied access to the...

Hi ppl.

I had the same problem with state 11. I found that the builtin\administrator group was denied access to the server and this caused the login to fail for users...

Hi

Sorry I did not add that if the you also have to check if dataset returns anything. Please let me know if you still have a problem

Hi

I do not know of a property to hide the whole body.

Just need some more info to see if I can help. Is the textboxes linked to datafields? Is the...

thanks for the reply

I want to avoid analizing text data, if possible. There is too many adhoc queries. I am talking off about 200 million queries to the databases per...

Hi there

On the schedule of the report there is an end date. This is when the report will stop auto run. You can set that to a date you see...

I would suggest changing the connection properties off the report you want disabled so that it gives an error when run, or moving them to a folder the user do...

That is exactly right. Both have one process ID. There is 2 instances under Services. Do you know how this happens so I can avoid it in future?

Thanks

The client network utility has no aliases setup.