Viewing 15 posts - 166 through 180 (of 2,008 total)
The procedure is running in the context of logged in user & he has rights to execute it. That is why it’s executing.
You need to understand Execution Context & Context...
February 11, 2012 at 5:10 am
I'm just a query hacker...
I believe there is serious Lingo Issue & you don’t mean what you have written. Still, I am not very comfortable in suggesting you anything...
February 11, 2012 at 5:02 am
I have worked on such projects (and coincidentally another Indian language Marathi). Actually you don’t need SQL Server’s Multi Language support for it. You just need it as data storage....
February 11, 2012 at 4:55 am
Jeff, I understand what you said. But many time business requirements drive the code (front end / back end).
If the requirement is to search any / all customers who...
February 11, 2012 at 4:44 am
Are you connected to Tempdb? Don’t you have any other database to create a table? Does the user account (that you are using) have rights to create a database? If...
February 11, 2012 at 4:31 am
Do you want to delete these records or want to archive to some other tables? For second scenario, Partitioning (SWITCH) will help you. It’s instant operation (metadata only).
If you want...
February 11, 2012 at 4:27 am
That’s it???
In my organizations, I don’t have access to any software (in fact very basic like notepad) which is not required for DEV & DBA work. No USBs, no cell...
February 11, 2012 at 4:13 am
It might be temporary issue. Did you try fresh SSMS window?
Also, are you using VPN on Client system? It disconnects the local system from the network (default behaviour, but can...
February 10, 2012 at 7:52 am
Do you get any time-out warnings / errors messages?
February 10, 2012 at 7:22 am
Didn’t get any chance to work upon ER Studio but worked on Erwin, PowerDesigner & Visio. All are nice and offer almost same features.
•Model Merge
•Model Split
•Model Compare
•Model SYNC
•Data Dictionary
•Naming Conversions
•Reverse...
February 10, 2012 at 7:05 am
If you are finding difficulty in expressing what you are looking for, here is something to start with...
Like Videos?
SQL Server Profiler Tutorial Video
http://sqlserverpedia.com/wiki/Using_SQL_Server_Profiler
Like Reading?
Using SQL Server Profiler
February 10, 2012 at 6:56 am
Search for 'Verify the domain' in following...
How to troubleshoot the "Cannot generate SSPI context" error message
February 9, 2012 at 9:08 am
Are Server & PC on different domains?
February 9, 2012 at 9:02 am
Did you try ‘sa’ login? I just want to make sure that you can make one successful login. Then we can focus on login specific issue.
February 9, 2012 at 8:35 am
First example from Google Search...
Temporary Tables vs. Table Variables and Their Effect on SQL Server Performance
http://www.codeproject.com/Articles/18972/Temporary-Tables-vs-Table-Variables-and-Their-Effe
February 9, 2012 at 8:19 am
Viewing 15 posts - 166 through 180 (of 2,008 total)