SELECT name FROM sys.tables WHERE name LIKE 'SomePatternAtTheStartOfTheTableName%'

Will give you all tables that start with "SomePatternAtTheStartOfTheTableName"

Clear? Sorry it took a while to get back I've been EXTREMELY busy..

CEWII

Ah, you know whats funny Lowell, I mentioned releasing my monitoring and logging project to codeplex way up in the chain, I am only now about ready to actually release...

sqlfriends (10/14/2011)

---

Thanks, will look into it.

Also if I can setup an alert notification using Policy management in SQL server to do similar thing like this?

I mean to notify the operator...

DNS ONLY (REPEAT ONLY) handles name resolution, it does NOT handle port assignments which are important for named instances.

What this means is that if you are current pointed at an...

It is a normal stored procedure stored in the master database that the sp_procoption sproc was used to make autotun. The sproc should not have any parameters. And...

Never seen that done, but I offer a different path.

It sounds like you want to walk through a set of tables based on their prefix, you could use a regular...

well started or restarted sure, look up autorun stored procedures. You could write one that sends an email and it would be triggered on those two cases. Stopped...

Gents,

I would not use any of these methods, I would use a SQLCLR to pull the file in.. And lo and behold we have been talking about some SQLCLR...

You are in luck, I just discovered this myself.

You have Policy Based Managed enabled and it is out of compliance, when the enabled policies are all complied with it disappears.

CEWII

From separate post..

They did hand us a very powerful dev platform in the SQLCLR. I think they just left us to our own devices on file handling. Elliott took the...

opc.three (10/13/2011)

---

Elliott Whitlow (10/13/2011)

---

Generally agreed, as far as misguided I do not.

Given a particular system it may make as much if not more sense to handle the file operations, whether...

battery_acid_h (10/13/2011)

---

Variables on package level are

User::EntryNo, type is Int32, value is 0

User::CompanyCode is String, Value is 'COMPANY'

Execute sql task has the following query

set @EntryNo = (-1)

set @EntryNo= (select EntryNo...

IF @@ERROR was 0 (zero) it could be asusmed all was well.

However, can I ask a different question, why do you want to go about building the command dynamically?

CEWII

opc.three (10/13/2011)

---

Personally I think using the CLR functionality to access files from with a T-SQL context, while preferable over using xp_CmdShell, is still a misguided application of the CLR. It...

I am unaware of any option or process which would allow you to run a package without validation, the closest you can come is the delayed validation.

I am curious...