Viewing 15 posts - 211 through 225 (of 629 total)
Try granting it references permissions ...
GRANT REFERENCES ON testpriv(id) TO test
After that I did not have any issues updating the table as Test user.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 26, 2009 at 11:55 pm
Also have a look at this ...
http://www.sqlteam.com/article/scheduling-jobs-in-sql-server-express
http://www.sqlteam.com/article/scheduling-jobs-in-sql-server-express-2
I have not read the entire article yet but seems like an interesting idea :).
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 26, 2009 at 11:38 pm
Michael (3/26/2009)
Hi.Is there an elegant way of defining a constraint to limit a NUMERIC(3,1) field to values between 0 and 10 in .5 increments thats not
CHECK ([field_Name] IN (0,.5,1,1.5,2,2.5,3,3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10)
Hi Michael...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 26, 2009 at 11:30 pm
Hi Rich,
A virtual name is what your users will access it by; it you need to have a DNS entry registered with that name and virtual serer IP...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 26, 2009 at 11:11 pm
I have not had that happen; I am running multiple installs of SSRS. I'll check it out when I get to work again tomorrow ...
But I would check no...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 26, 2009 at 11:01 pm
You are not excluding HEAP, instead of excluding cluster indexes
Try this for disabling indexes ... just made few adjustments..
DECLARE @schemaname sysname
DECLARE @tablename sysname
DECLARE @objectid sysname
DECLARE @indexname sysname
DECLARE tables_cursor CURSOR...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 26, 2009 at 10:45 pm
Mike Levan (3/26/2009)
1. Query Time out Expired
2. Execution terminated by the provider because a resource limit was reached.
3. Query Wait time -...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 26, 2009 at 10:10 pm
Markus (3/26/2009)
The thing is that we did not have this issue on the old server hardware and this issue starts about...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 26, 2009 at 2:56 pm
Yaa our Disk guys tell us that too; I still do it!
I have always noticed performace improvement. Other thing how many CPU you have and how many Data files...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 26, 2009 at 11:44 am
Right DBCC does put heavy load on the server; I would not be concerned in your system. Unless that starts happening in during business hours.
How is your tempdb setup?
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 26, 2009 at 10:21 am
I am performace tuning a SQL Server with this issue right now. This is caused by bottle neck in I/O as Microsoft said. Problem is it Disk guys...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 26, 2009 at 8:45 am
Sorry I have never used ArcServe Agent, I like native SQL Server Backups more :).
I did a quick search on google and it seems alot of people are complaining...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 26, 2009 at 8:14 am
2 Tim 3:16 (3/26/2009)
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 26, 2009 at 7:33 am
Duplicate post, replies started here already.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 25, 2009 at 11:22 pm
Duplicate post, Replies here please.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 25, 2009 at 11:17 pm
Viewing 15 posts - 211 through 225 (of 629 total)