Viewing 15 posts - 61 through 75 (of 162 total)
One solution would be to perform a REPLACE of your search variable before performing the search. This would allow you to replace 'o' with '[oó]'.
set @strName = replace(@strName, 'o',...
May 1, 2003 at 4:30 am
scope_identity() will return the value of the identity column when you insert a new row into a table, it is therefore acting at a table level and not a column...
April 30, 2003 at 7:03 am
You need to escape the single quote with another single quote like this.
insert into a1 values('This is Soumil''s laptop')
April 29, 2003 at 10:32 am
Thanks DavidB & ian.......(have you guys been talking to each other)???
April 10, 2003 at 10:23 am
April 10, 2003 at 9:30 am
ian
Thankyou for your reply, clearly from your configuration I can see justification for Log Shipping being unaffected by other backups being taken in parallel to Log shipping.
However, (my question b))...
April 10, 2003 at 9:24 am
The script generated from the old server could contain the collation information (SQL 2K puts it in by default when scripting).
From EM, you can see the collation settings for the...
March 18, 2003 at 6:17 am
You say "new server".....did you restore backups from the old server to the new one in your migration?
Are you sure the collation on the new server is the same as...
March 18, 2003 at 6:09 am
You could consider creating a DTS Package which transfered the Stored Procedure(s) with a Transfer SQL Objects task. The DTS Package could then be programmatically called with xp_cmdshell.
February 27, 2003 at 2:27 am
Does this help?......
How can I protect against SQL Injection attacks?
Answer: If your web servers happen to have a database backend (i.e. nearly all servers in commercial environments), SQL Injection...
February 18, 2003 at 2:26 am
For Steve Jones an email reply I received from Microsoft....
"Yukon will include Microsoft's IntelliSense auto-complete technology and its Visual SourceSafe source code control system.
I guess your wish is granted...
February 18, 2003 at 2:22 am
Have you taken a look at the DATABASEHAMMER included in the SQL Server resource kit.
February 13, 2003 at 2:21 am
In addition to the transactional support you mention here I think you have to also be aware that if a memory table is going to process a large amount of...
February 13, 2003 at 2:10 am
The sysjobhistory table stores this information in the following fields
run_date (YYYMMDD)
run_time (HHMMSS)
run_duration (HHMMSS)
where exactly is your problem?
February 12, 2003 at 4:26 am
There is a good article on http://www.sqlmag.com regarding UDF performance.
InstantDoc #25630
....but you have to subscribe to the magazine to view the article.
February 12, 2003 at 2:54 am
Viewing 15 posts - 61 through 75 (of 162 total)