Viewing 15 posts - 91 through 105 (of 201 total)
shinaliju (7/18/2008)
hi,I would like to know how to take a backup of aserver and load it into another server...
plz help me..
are you planning to move databases from one server to...
July 22, 2008 at 2:46 am
vanessab (7/22/2008)
Try :sp_helplogins 'LoginName'
thats true..you could also use :
sp_helpuser youruserid
🙂
July 22, 2008 at 2:42 am
maruf.khan (7/21/2008)
can u giv 1 example which u hav seen is not workingthkz for the reply
one example would be, one job that we had actually scripted out in sql...
July 21, 2008 at 4:49 am
Msg 156, Level 15, State 1, Line 36
Incorrect syntax near the keyword 'FETCH'.
Msg 156, Level 15, State 1, Line 43
Incorrect syntax near the keyword 'DEALLOCATE'.
Msg 156, Level 15, State 1,...
July 21, 2008 at 4:45 am
maruf.khan (7/21/2008)
Set the compatability level to 90Can any 1 explain y do we need to change compatability level to 90
wat is an issue with compatability level 80.......:)
Compatibility level in sql...
July 21, 2008 at 4:30 am
sqlservering (7/21/2008)
vidhya sagar (7/20/2008)
Check out the link belowHi I am pretty new to sql server, what is the use of profiler??
Profiler helps to identify and watch sql server performance, it...
July 21, 2008 at 2:22 am
GilaMonster (7/21/2008)
When use an index - Anytime you want a query to run without having to scan the entire table to...
July 21, 2008 at 2:20 am
rinu philip (7/21/2008)
thanks:)
thanks the info was helpful
July 21, 2008 at 1:31 am
Sandy (7/21/2008)
rinu,go through below links.
http://msdn.microsoft.com/en-us/library/ms188783.aspx"> http://msdn.microsoft.com/en-us/library/ms188783.aspx
http://www.sql-server-performance.com/articles/per/index_data_structures_p1.aspx"> http://www.sql-server-performance.com/articles/per/index_data_structures_p1.aspx
http://www.odetocode.com/Articles/70.aspx"> http://www.odetocode.com/Articles/70.aspx
Cheers!
Sandy.
http://www.odetocode.com/Articles/70.aspx--good one..thanks
July 21, 2008 at 1:18 am
Sandy (7/21/2008)
Rinu,
---------------------------------------------------------------------------------------------------------
Hi Sandy, am using for about 1.5 years why??
I think you may have gone through this concepts in the beginning of your career, then why are you asking...
July 21, 2008 at 1:04 am
GilaMonster (7/21/2008)
July 21, 2008 at 12:37 am
usman asghar (6/5/2008)
I am working on a problem in which i have to apply sort on a table based on elements of an XML column.
I have attached an image of...
July 21, 2008 at 12:31 am
Sandy (7/20/2008)
gail,we can also get the idea from the service manager
(Control Panel-->administrative tool), if i am not wrong.......
Cheers!
Sandy.
Gail/Sandy,
I actually wanted to know what are the different processes that are involved...
July 21, 2008 at 12:17 am
Sandy (7/20/2008)
Renu, good question..:)rinu, since how long you are using Sql server?
Hi Sandy, am using for about 1.5 years:) why??
July 21, 2008 at 12:11 am
Viewing 15 posts - 91 through 105 (of 201 total)