Viewing 15 posts - 6,571 through 6,585 (of 7,168 total)
Horatiu Ripa (4/22/2011)
Is there a way to find out which are the records not referenced...
April 22, 2011 at 10:15 am
Selahattin SADOGLU (4/21/2011)
After migrating data from SQL Server 2000 to SQL Server 2008,when I am doing any a transaction in the table which find out more row on the...
April 22, 2011 at 9:59 am
anu.suresh.hema (4/22/2011)
I am kind of new to SQLServer and my question involves query timeout in stored procedures.I have a stored procedure that uses "WAITFOR DELAY " and sleeps for say,10...
April 22, 2011 at 9:07 am
It will be very difficult to help if you do not provide more information. Please have a look through this article: http://www.sqlservercentral.com/articles/SQLServerCentral/66909/%5B/url%5D
April 21, 2011 at 4:05 pm
That will certainly work. If you're on 2008 you'll want to use sqlcmd which should also let you do the same thing. osql is a SQL 2000 tool and AFAIK...
April 21, 2011 at 3:34 pm
PS I agree with Stefan, favor stored procedures over embedded SQL. There is a section in the article from my previous post that shows an example using a stored procedure...
April 21, 2011 at 2:27 pm
dianaansari (4/21/2011)
When I debug my web-page it shows me this error:
Must declare...
April 21, 2011 at 2:25 pm
Ninja's_RGR'us (4/21/2011)
Syed Jahanzaib Bin hassan (4/21/2011)
Read this page from microsoft,you hit and trial people,you people have limited knowledge i think so
http://msdn.microsoft.com/en-us/library/ms165724(v=sql.90).aspx
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP |...
April 21, 2011 at 1:57 pm
toddasd (4/21/2011)
SET ROWCOUNT overrides the SELECT statement TOP keyword if the rowcount is the smaller value.
SET ROWCOUNT is ignored in INSERT, UPDATE,...
April 21, 2011 at 11:04 am
Ninja's_RGR'us (4/21/2011)
Syed Jahanzaib Bin hassan (4/21/2011)
CONTROL-PANAL ->Administrative Tools -> Services
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP...
April 21, 2011 at 10:53 am
Grant Fritchey (4/21/2011)
If it returns multiple rows, only the last one returned will end up in the variables.
I formed a habit from the beginning to explicitly grab one row when...
April 21, 2011 at 10:10 am
It's only evidence if someone else quotes you 😀
April 21, 2011 at 10:02 am
MarvinTheAndriod (4/21/2011)
Although you can log onto them if you know the server address.
Clarification please:
"server address" = explicit IP address?
Can you log in using server_name\instance_name?
ip_address\instance_name ?
server_name,port_number ?
April 21, 2011 at 9:47 am
forsqlserver (4/21/2011)
Thanx..By mistake I have run the sqluser1.
Problem is still same I want to test the user sqluser1's permission:-)
sqluser1 is a database user associated to the login...so if you do...
April 21, 2011 at 7:47 am
Viewing 15 posts - 6,571 through 6,585 (of 7,168 total)