I am getting this error and can figure it out, I am new to SQL so please be detailed on resolution.
Msg 229, Level 14, State 5, Procedure xp_cmdshell, Line 1
The EXECUTE permission was den...
Can I use SQL Server 2008 Workgroup Edition (5 client) as database on my webserver storing different websites? I have installed Windows 2008 Server and need a database. Just got SQL Server 200...
whether scom 2007 requires sql 2005 only, its not supported on sql server 2008.............our OS is windows 2003...database is sql 2008 but scom is not taking sql 2008 databse, so its support...
When installing SQL Server 2008 64Bit on Windows Server 2008 64Bit I get a, "Known Compatibility Issues" warning that states to download SQL Server 2008 SP1 before running the program for the ...
Hello All,
I'm trying to build an update or insert SP, but seem to be getting a little lost with this, I think the SP I'm trying to build below is fairly self explanotory, but let me know i...
This is an unfortunate case of an over-documented problem. The issue I am having is likely not a typical login problem to SQL.
Here are some basic facts:
* SQL 2008 Standard on WIndows ...
i´m trying to restore sql 2005 db to sql 2008 but i allways get the sam error for every db
can some help me please
b. how to truncate/shrink log files in sql server 2008?? the below command NOT seems to work in sql server 2008... i use it in sql server 2000.. it gives error in TRUNCATE ONLY.
i just want ...
I used before SQL 2000, and when i generate the scripts for the store procedures, the generated file had this command for each strore procedure : "If exists ....... then drop ". This mean tha...
Hello,
I have a Vista 64-bit machine which used to run the 32-bit versions of MS SQL Server 2005 & 2008 Express with Advanced Services. I uninstalled SSEE in preparation for installing the...
I installed SQL Server 2008 Standard (a very basic bare bones install on Vista 32-bit for development and educational purposes). I don't have much else installed on this system. When I tried...
Hello everyone. I have a SQL 2008 cluster running on two Windows 2008 Enterprise physical servers. I already have an instance of SQL Server running, MSSQLSVR. I need to add Reporting Services....
I have been working on a small project to draw significant amounts of data from a MySQL database as a linked server to a SQL Server database with a different format. The code all looks good a...
I have a fresh install of SQL Server 2008 and am having trouble starting the SQL Agent process. Each time I try to start it, I get the message "The SQL Server Agent Service on Local computer ...
I need AdventureWorks2008 installed on my SQL Server 2008 database in order to go through the exercises for a Microsoft certification. A friend sent me his copy of AdventureWorks2008_Data.mdf...
My attempt of SQLServer 2008 SP1 install failed. Please advise on the attached error. Thanks.
Hi!
I have a SQL server Express installed on my server and if i use Sql Server Management Studio and connect it works really fine, i like it. But when i try to connect from my client (also Sq...
Hi
I have a problem with my SQL Server dropping connections
If I look in the event viewer on the server I find a lot of messages like "The client was unable to reuse a session with SPID...
Im going through a book on performance tuning and it keeps telling me to compare query costs; but, I dont know where to find them. The execution plan gives a breakdown of sub part costs but ...
Im creating a view by joining a number of tables. the default format of a date time column in my table is MM/DD/YYYY HH MM ./........
how do i convert that to a simple MM/DD/YYYY
Has anyone found a way to send a query as a csv file attachment that displays properly in Excel? When I open the file, Excel doesn't seem to recognize the delimiters & lumps the full row into ...
I'm logged into the 2008 server with the domain admin account, which has all the default rights. I'm trying to install a new SQL failover cluster from the SQL 2008 Installation Center. On the ...
Good afternoon! I've run into an interesting issue where one of our servers is unable to load service pack 1 for sql server 2008. I've tried getting it both from our wsus server, and loading...
Is it good idea to use SQL Server 2008 - Express Edition for 25 users?
Im using a SQL 2008 machine and connecting to a db on a SQL Server PE machine. My data feeds from the outside to the SQL PE box. This setup I cannot change. I can t bypass SQL PE.
I have...
