Viewing 15 posts - 136 through 150 (of 187 total)
To go with your code
DECLARE @lonlat as geography
set @lonlat = geography::STPointFromText('POINT (122.236418 45.754767)', 4326);
select @lonlat.Lat
should get it for you.
February 10, 2009 at 8:14 am
run select @ @version to get the version of SQL.
More than likely you issues is that you are trying to attach a 2005 DB to a 2000 server.
ETA: Put...
February 10, 2009 at 7:19 am
There are a few things to try with this.
1. Check MSDTC within Component Services and be sure that you have it set to Allow Remote Clients.
2. Within...
February 10, 2009 at 7:17 am
You could try logging into a machine using that account/password (assuming you have that). If the login fails, you know the password was reset to something and you...
February 10, 2009 at 6:57 am
In my experience SQL Server loves memory (especially on servers that are heavily used, since it will do what it can to put pages in memory).
If you feel that it...
February 10, 2009 at 6:53 am
Oddly enough the headline article for SQL Server Central today discusses two pretty easy ways to get that.
February 5, 2009 at 2:39 pm
Just looking strictly as the sysprocesses information, they do the exact same thing. I have one window open in SSMS to view the process data and then...
February 5, 2009 at 2:24 pm
If you have the profiler data you certainly have an excellent start.
It is not really just matter of those running the longest (though that is a good starting point) you...
February 5, 2009 at 2:08 pm
If there are some specific times during the day that this runs, I would schedule a trace to run (or just open profiler and see what all is running when...
February 5, 2009 at 1:53 pm
The bare essentials that you would need would be a connection and an Execute SQL task.
Within the connection you would point it to your 2005 server and the db containing...
February 5, 2009 at 1:09 pm
There are a whole bunch of ways that you could do this, obviously everything mentioned above will work just fine.
If you want to create a custom SSIS package to copy...
February 5, 2009 at 12:36 pm
CrazyMan (2/3/2009)
This would have been ideal if i am dealing with numbers, the problem is that the table...
February 3, 2009 at 12:03 pm
Creating an auxiliary table of numbers is something I find useful on most servers for one reason or another (Itzik Ben-Gan frequently has information that utlizes nums and as far...
February 3, 2009 at 9:44 am
This is similar to the above and still not ideal but if you have a nums table you could certainly join back to that and Coalesce. (for creation of nums...
February 3, 2009 at 9:20 am
I am assuming you have set up the Alert System within the Properties of the Agent, outside of that you do have to restart the SQL Agent after you have...
February 2, 2009 at 9:44 am
Viewing 15 posts - 136 through 150 (of 187 total)