Hi All, Has anyone applied SQL Server SP4 and demonstrated the AWE problem, then applied the hotfix and seen the AWE problem corrected? Regards, Swamy...
It doesnt work perfectly fine we applied it in UAT , But unfortunately it is still giving AWE Errors.We have launched a BUG with PSS team at Microsoft and...
Hi, Microsoft has specified an hotfix for the AWE problem. I think its KB899761 if I am not wrong. We have applied it and we did not find any problem till now....
I need your help! Please help me __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection...
hi guys I have created new users with specific permissions to create table or read permission.Now that a user create a table it will be created in his...
Hi Vijay, The default user of the database is dbo. So when u try to access any table then it will try to search in that context. If you are creating a table as...
help on what? if that is too urgent then press F1 ... ____________________________________________________ Start your day with Yahoo! - make it your home page ...
Hi Viswanath, I too agree that when it comes to performance issue, the method you have suggested will be a better approach. But when it comes to backup or...
Hi all I am using sp_executesql sp. I am getting the following error Msg 15151, Level 16, State 1, Line 1 Cannot find the user '@Name_p', Please help me on...
Hi all I am having some problem with executesql. Please have a look at the SP I created. While executing this SP in sql 2005 I am having the following error ...
Hi First of all, if possible, try not to stored images and other binary files in the SQL Server tables, as they slow things down. Instead, store a link (file...
Hi Vijay, Why don't you try this SET @InsertString = N'grant execute on temp_del to ' + @Name_p hth - Mei vijaykrishnabodi <vijaykrishnabodi@...> wrote: ...
try out the folowing ... CREATE PROCEDURE GrantExe_TempDel @Name varchar(500) AS DECLARE @InsertString NVARCHAR(500) SET @InsertString = 'grant execute on...
Directory backups.Delete images when records are deleted.. ... you have suggested will be a better approach. ... too should be taken as backups. One finds...
Hi, I have checked a procedure performance on Application prog and Query analyzer. I have seen both have different CPU timing, duration timing and read data on...
Hi, Yes, SQL Server caches the queries and their e-plan (Execute plan). If I am correct, you might have execute the SP before you take these metrics. Group:...
Hi Vishwanath, Fine I too appreciate your idea. I am working for one of the leading banks and there are 29,000 employees on role and 1000 consultants. All the...
Sujoy The advantage i see in maintaining in folders is with regards to maintainability of databases.the databases maintainance is going to be simple and...
Hi All, This is to inform you all that, I had lost my money sum of (cash) 21,100/- inside my cabin at MS campus on Saturday (06.08.2005). Immediately I had...
Hi All I have situation where I need to optimize disks space in order to install database. Space should be include for regular database backup and log...
Hi, I have seen lots of audit login failed by HOST Name Server in my sql server . How i can checked such unathorished user How to trap his IP to take further...
Hi Uday , These all are vast topics and i suggest you to please to sysrt with beginners tutorials and books.. Though i can give you a small example : Suppose...
Hi Udhay, Replication - Its nothing but creating the replica of a database in another server. The data will be moved from the one database to another.At any...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
