both SQL and Oracle support pattern matching for any character:

select * from YourTable

where YourColumn like '%H_M%'

SQL supports a type of regular expression like this:

select * from YourTable

where YourColumn like...

the views ALL_TAB_COLUMNS / USER_TAB_COLUMNS has the table name and the raw column info like column name, data type, column id , etc just like our sys.columns;

is that what...

for any browser to try and create/render a drop down menu (html <select>)

with 600K objects, i'd figure you are looking at a render time in minutes; closer to 10 minutes...

i'm just throwing a guess out here, but I don't think you should be building a connection string...

in all my CLR,s when I declare a SQL connection, i do it...

you need to be able to also join against a master list of all sites.

when you cross join dates and sites, you get all possible values...which you can then join...

answering my own question, now that I've been caffeine infused:

i was looking for the border-collapse:collapse; property, usually applied on the table tag.

i believe in 2008 and above, they tightened the security rules on who gets admin of the sql server, and Builtin\Administrators was removed, so you have to be explicitly added...

most likely a permissions issue.

to run a cumulative update, you need to be an administrator ont he amchine...

xp_cmdshell does not run as the logged in user...it runs under whatever the...

here you go:

CREATE ROLE DatabaseUser

EXEC sp_addrolemember N'db_datareader', N'DatabaseUser'

CREATE ROLE DatabaseDeveloper

EXEC sp_addrolemember N'db_ddladmin', N'DatabaseDeveloper'

EXEC sp_addrolemember N'db_datareader', N'DatabaseDeveloper'

EXEC sp_addrolemember N'db_datawriter', N'DatabaseDeveloper'

you need to create a user on the AS400 that has read only permissions.

then when you create the linked server, use that specific user for the remote login.

it is...

Sanz (2/15/2012)

---

Strange ! GRANT VIEW ANY DEFINITION was run against a Login and it was run in master. Still the permission does not reflect in other db's. Am I missing...

i'm pretty sure GRANT VIEW ANY DEFINITION TO LOGIN is a server scope command...it has to be against a login and not a user, and your database has to be...

is that logic right?

i don't think you need to go to the dmvs, first of all...

second, this pretty much says "if you find any of these conditions, even if it's...

sql runs as a service, it's main executable is not double clickable/runable...you go to Control Panel Administrative tools>>Services and see if it is running there or not (you can use...

lol my shops IT budget doesn't have room for any software that would make my life easier; it pretty much covers absolutely required hardware + licenses.

If i wanted something like...