this is normal; the execution plan is cached;

when you create a proc/function/view, and it features SELECT * FROM, behind the scenes the actual query is stored as SELECT Col1,Col2,Col3.... for...

Nagesh S-432384 (5/21/2010)

---

TRUNCATE TABLE permissions is default to the members of the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles. I think you should be able...

yep, what you posted matches what i have in my snippets, captured from some other post on the same subject:

The main clauses in SQL are logically executed in the following...

just the "thank you" you already gave us is enough; we all apreciate receiving that!

it's fairly simply, just pass in the format string you want to use; if you are familiar with the CONVERT(date,StyleNumber), many of the typical formats are built in:

declare @TheDate datetime

SET...

glad i could help a bit!

when you take a backup, it gets the data, and then the log of all changes as well; so say you had a backup that was huge, and took...

your right, I think it's permissions;

the account that SQL is running under, are you SURE it has access to the C:\Users\jwilliams\Documents\ folder and all it's sub folders?

since you've used CmdShell...

here's a screenshot to uninstall;

also, i believe if you go to the Surface Area Configuration, you can add yourself(windows login) as an administrator to your instance,a dn then change the...

if you can login with your windows login, it doesn't matter what the current password is for sa, just change it to a new, known password: you can rightclick>>Properties of...

select * from sys.all_objects where type_desc = 'SYSTEM_TABLE' --all sys tables

select * from sys.all_objects where type_desc = 'USER_TABLE' and is_ms_shipped = 0 --all user tables

aside from...

duplicate post, do not reply to this thread.

continue the discussion here

anjani_aim (5/21/2010)

---

I have 4 database with same structure. we have to integrate it into single database.All 4 database has same tables. there are some tables having identity key which have...

late binding of objects are a feature of stored procedures; you can reference a non existent table/view/procedure/function without raising an error. the references will be checked when the procedure is...

MC here's some basic steps; the first thing you need is access to an actual mail server , and the email/username/password used to login to the mail server; i believe...