Viewing 15 posts - 5,566 through 5,580 (of 13,468 total)
I just did a quick proof of concept, and my first thought is you can't do it without some changes/find replace in the code just before you execute it...the functions,...
April 25, 2012 at 6:21 am
the timeouts probably has a lot more to do with the WHERE statements that is the part of the query.
the execution plan that is created/reused to satisfy the WHERE clause...
April 25, 2012 at 5:58 am
here's an example of providing your data in a readily consumable format:
i took your post and ran it thru a few find-and-replace macros to get it like this:
With MySampleData (...
April 24, 2012 at 2:49 pm
the data types remain as they were.
the data types text, ntext and image are still valid data types, but it is recommended to change them to the newer types...
April 24, 2012 at 5:28 am
PSB (4/23/2012)
I have a table named ABC. It has a field named Y and Z.
Y='ABCDEFG (9105) CDD ABCDEFG (1690) ENGINEERING'
I want to find the second instance of...
April 23, 2012 at 12:35 pm
additionally, when you append strings together to create commands, you need to include spaces between the words.
'GRANT' || staff_id|| 'TO' || username ||'';
will make a string like "GRANTstaff_idTOLowell"
April 22, 2012 at 8:27 pm
Sapen (4/20/2012)
Lowell (4/20/2012)
April 20, 2012 at 9:30 am
i thought the catalog view he's refering to in the object Explorer returns the results of sp_tables_ex linkedservername , so whether the linked server is SQL Server, Oracle, mysql, a...
April 20, 2012 at 8:55 am
Sapan i thought that the catalog gets populated with only the tables/objects of the default database assigned to the login you are using to connect with...so for example if my...
April 20, 2012 at 8:46 am
dakshinamurthy-655138 (4/20/2012)
Hi,Please let me know if this logon trigger which is used to Restrict the connection to several IPs will have performance issues, where the concurrent users are more.
You said...
April 20, 2012 at 4:46 am
your role looks fine, so it's got to be that either the individual or the group is in some other roles, like sysadmin roles, that is giving more permissions.
run variations...
April 16, 2012 at 3:46 pm
Pink123 (4/16/2012)
Can someone help me with a query to do so.
I am confused about how to...
April 16, 2012 at 9:49 am
Pink123 (4/13/2012)
Thanks but if I want to set the update date as some date in past ,how do I do that?
sounds way too much like you are trying to falsify...
April 13, 2012 at 1:02 pm
ALTER LOGIN bob DISABLE;
ALTER LOGIN bob ENABLE;
after you've disabled and re-enabled the login, the updatedate will be the moment the last event occurred( the enable)
April 13, 2012 at 12:04 pm
Viewing 15 posts - 5,566 through 5,580 (of 13,468 total)