Viewing 15 posts - 1,066 through 1,080 (of 1,478 total)
If you want to know how to pass the parameters to the stored procedure, you do it the exact same way that you would do it if you were working...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 25, 2009 at 6:47 am
Laura Schmalzbauer (3/25/2009)
I'm referring to when a table was inserted into or deleted from.
For that you'll have to use trace or trigger or to use stored procedure to allow data...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 25, 2009 at 6:34 am
Laura Schmalzbauer (3/25/2009)
I'm referring to when a table was inserted into or deleted from.
For that you'll have to use trace or trigger or to use stored procedure to allow data...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 25, 2009 at 6:09 am
Here is the query that I'm using. I found it once on one of the SQL Server forums, but I don't remember where.
SELECT name AS 'File Name' , physical_name...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 24, 2009 at 4:08 am
The update statement has to do a table scan in order to find which record met the specified criteria in the where clause. Since the first process is still...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 23, 2009 at 11:19 pm
When you look at the job’s history, you can check the checkbox that shows the job’s steps. This will give you a bit more information about the error. ...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 23, 2009 at 10:59 pm
Your post is not very clear. Do you want to get only the records that have only numbers or do you want to get all the records but remove...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 23, 2009 at 2:27 am
Casper (3/20/2009)
One more permission related issue: If I execute this: EXEC sp_addrolemember 'db_datareader', 'User_Name_Here'
It give the user SELECT permissions on tables , but not views.
How can...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 20, 2009 at 3:09 am
When you create the database, you can decide how much the file should be increased. If you use the GUI the default is 10%. I have to admit...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 20, 2009 at 1:09 am
SQL Reddy (3/19/2009)
Then import the data from the...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 20, 2009 at 1:00 am
Chirag (3/20/2009)
But In BOL under Create table sections...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 20, 2009 at 12:48 am
The answer has to be maybe. If you don’t violate the rules for ownership chain, then the answer would be yes, but if you did something that breaks the...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 19, 2009 at 6:05 am
I also tried script # 2 and it worked with no problem at all. While you run it, can you check the DMV sys.os_waiting_tasks and see if you can...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 19, 2009 at 5:58 am
Can you show us what you tried and what error you got? I’ve done if few times with no problems at all.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 19, 2009 at 5:24 am
I was looking for an option that will say that the query will cause an error (because of the missing group by) but I didn’t find one. I ignored...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 18, 2009 at 2:34 am
Viewing 15 posts - 1,066 through 1,080 (of 1,478 total)